Home Microsoft SQL Server DigiMailing iRN Contact
    Keyword



sys.objects

  No additional text.


Syntax
CREATE VIEW sys.objects AS
	SELECT name, object_id, principal_id, schema_id, parent_object_id,
		type, type_desc, create_date, modify_date,
		is_ms_shipped, is_published, is_schema_published
	FROM sys.objects$

 
Last revision 2008RTM
See also

  all_extended_procedures (View)
all_objects (View)
check_constraints (View)
COLUMNS (View)
COLUMN_DOMAIN_USAGE (View)
COLUMN_PRIVILEGES (View)
CONSTRAINT_COLUMN_USAGE (View)
CONSTRAINT_TABLE_USAGE (View)
crypt_properties (View)
default_constraints (View)
dm_os_memory_objects (View)
dm_xe_objects (View)
DOMAIN_CONSTRAINTS (View)
extended_procedures (View)
foreign_keys (View)
key_constraints (View)
numbered_procedures (View)
numbered_procedures$ (View)
objects$ (View)
PARAMETERS (View)
procedures (View)
ROUTINES (View)
ROUTINE_COLUMNS (View)
service_queues (View)
spt_all_procedures (View)
spt_check_constbytable_rowset (View)
spt_columns_odbc_view (View)
spt_columns_view (View)
spt_columns_view_managed (View)
spt_column_privileges_owner_view (View)
spt_column_privileges_set_view (View)
spt_indexcolumns_view_managed (View)
spt_indexes_view (View)
spt_indexes_view_100 (View)
spt_indexes_view_managed (View)
spt_parameters_numbered_parameters (View)
spt_procedures_system (View)
spt_procedures_user (View)
spt_procedure_params_managed_view (View)
spt_procedure_params_return_values_managed_v (View)
spt_procedure_params_return_values_view (View)
spt_procedure_params_view (View)
spt_sparse_columns_view (View)
spt_tablecollations_view (View)
spt_tables_info_view (View)
spt_tables_view (View)
spt_table_privileges_view (View)
spt_table_types_view (View)
spt_table_type_columns_view (View)
sp_ActiveDirectory_Obj (Procedure)
sp_ActiveDirectory_SCP (Procedure)
sp_addmergearticle (Procedure)
sp_addmergefilter (Procedure)
sp_addpullsubscription (Procedure)
sp_addsynctriggers (Procedure)
sp_addsynctriggerscore (Procedure)
sp_addtabletocontents (Procedure)
sp_articlesynctranprocs (Procedure)
sp_autostats (Procedure)
sp_bindefault (Procedure)
sp_bindrule (Procedure)
sp_cdc_create_objects (Procedure)
sp_cdc_ddl_event_internal (Procedure)
sp_cdc_disable_db_internal (Procedure)
sp_cdc_disable_table_instance (Procedure)
sp_cdc_drop_change_table_objects (Procedure)
sp_cdc_drop_objects (Procedure)
sp_cdc_enable_db_internal (Procedure)
sp_cdc_enable_table_internal (Procedure)
sp_cdc_get_capture_instances (Procedure)
sp_cdc_logddl_internal (Procedure)
sp_cdc_vupgrade (Procedure)
sp_changedistributor_property (Procedure)
sp_changemergearticle (Procedure)
sp_changemergefilter (Procedure)
sp_changeobjectowner (Procedure)
sp_check_constraints_rowset (Procedure)
sp_check_constraints_rowset2 (Procedure)
sp_check_for_owned_jobs (Procedure)
sp_check_for_sync_trigger (Procedure)
sp_check_join_filter (Procedure)
sp_check_removable_sysusers (Procedure)
sp_check_subset_filter (Procedure)
sp_check_sync_trigger (Procedure)
sp_column_privileges (Procedure)
sp_constr_col_usage_rowset (Procedure)
sp_constr_col_usage_rowset2 (Procedure)
sp_copysubscription (Procedure)
sp_createagentparameter (Procedure)
sp_createagentparameterlist (Procedure)
sp_createstats (Procedure)
sp_dbcmptlevel (Procedure)
sp_delete_job_references (Procedure)
sp_depends (Procedure)
sp_dropdistributor (Procedure)
sp_dropmergearticle (Procedure)
sp_estimate_data_compression_savings (Procedure)
sp_execresultset (Procedure)
sp_execresultset_nvarcharmaxrows (Procedure)
sp_extended_logging (Procedure)
sp_fkeys (Procedure)
sp_foreign_keys_rowset (Procedure)
sp_foreign_keys_rowset2 (Procedure)
sp_foreign_keys_rowset3 (Procedure)
sp_fulltext_catalog (Procedure)
sp_getarticlepkcolbitmap (Procedure)
sp_getpublisherlink (Procedure)
sp_getqueuedrows (Procedure)
sp_getsqlqueueversion (Procedure)
sp_help (Procedure)
sp_helpconstraint (Procedure)
sp_helpdistributor_properties (Procedure)
sp_helpmergearticle (Procedure)
sp_helpmergearticleconflicts (Procedure)
sp_helpmergedeleteconflictrows (Procedure)
sp_helpmergefilter (Procedure)
sp_helpmergepullsubscription (Procedure)
sp_helprotect (Procedure)
sp_helptext (Procedure)
sp_helptrigger (Procedure)
sp_help_alert (Procedure)
sp_help_fulltext_columns (Procedure)
sp_help_fulltext_columns_cursor (Procedure)
sp_help_fulltext_tables (Procedure)
sp_help_fulltext_tables_cursor (Procedure)
sp_help_notification (Procedure)
sp_help_spatial_index_internal (Procedure)
sp_IHarticleview (Procedure)
sp_IHScriptSchFile (Procedure)
sp_instdist (Procedure)
sp_link_publication (Procedure)
sp_mergearticlecolumn (Procedure)
sp_mergesubscription_cleanup (Procedure)
sp_MSaddautonosyncsubscription (Procedure)
sp_MSaddexecarticle (Procedure)
sp_MSaddguidcolumn (Procedure)
sp_MSaddmergeschemaarticle (Procedure)
sp_MSaddmergetriggers (Procedure)
sp_MSaddmergetriggers_internal (Procedure)
sp_MSaddschemaarticle (Procedure)
sp_MSaddupdatetrigger (Procedure)
sp_MSadd_mergereplcommand (Procedure)
sp_MSagent_access_check (Procedure)
sp_MSarticlecleanup (Procedure)
sp_MSarticle_validation (Procedure)
sp_MSchangeobjectowner (Procedure)
sp_MScheck_functions_directly_in_view (Procedure)
sp_MScheck_functions_indirectly_in_view (Procedure)
sp_MScheck_join_filters (Procedure)
sp_MScheck_subset_filters (Procedure)
sp_MScleandbobjectsforreplication (Procedure)
sp_MScleanupdynsnapshotvws (Procedure)
sp_MScleanupmergepublisherdb (Procedure)
sp_MScomputemergearticlescreationorder (Procedure)
sp_MScomputemergeunresolvedrefs (Procedure)
sp_MScontractsubsnb (Procedure)
sp_MScreateandsetarticleprocs (Procedure)
sp_MScreatebeforetable (Procedure)
sp_MScreatedisabledmltrigger (Procedure)
sp_MScreatelightweightarticleprocs (Procedure)
sp_MScreate_article_logical_record_views (Procedure)
sp_MScreate_article_repl_view (Procedure)
sp_MScreate_common_dist_tables (Procedure)
sp_MScreate_distributor_tables (Procedure)
sp_MScreate_dist_tables (Procedure)
sp_MScreate_peer_tables (Procedure)
sp_MScreate_pub_tables (Procedure)
sp_MScreate_sub_tables_internal (Procedure)
sp_MScreate_tempgenhistorytable (Procedure)
sp_MSdefer_check (Procedure)
sp_MSdeletelightweightsubscription (Procedure)
sp_MSdependencies (Procedure)
sp_MSdetectinvalidpeerconfiguration (Procedure)
sp_MSdisableautonosync (Procedure)
sp_MSdoesfilterhaveparent (Procedure)
sp_MSdroparticleconstraints (Procedure)
sp_MSdroparticleprocs (Procedure)
sp_MSdropconstraints (Procedure)
sp_MSdropdisabledmltrigger (Procedure)
sp_MSdropfkreferencingarticle (Procedure)
sp_MSdropmergearticle (Procedure)
sp_MSdrop_article_conflict_table (Procedure)
sp_MSdrop_cdc (Procedure)
sp_MSdrop_ins_conflict_proc (Procedure)
sp_MSdrop_object (Procedure)
sp_MSdrop_pub_tables (Procedure)
sp_MSdrop_repltran (Procedure)
sp_MSdrop_synctran_objects (Procedure)
sp_MSenableautonosync (Procedure)
sp_MSenumchangesdirect (Procedure)
sp_MSenumchanges_belongtopartition (Procedure)
sp_MSenumpartialchangesdirect (Procedure)
sp_MSestimatemergesnapshotworkload (Procedure)
sp_MSflush_access_cache (Procedure)
sp_MSforeachtable (Procedure)
sp_MSgenerateexpandproc (Procedure)
sp_MSgen_sync_tran_procs (Procedure)
sp_MSgetconflictinsertproc (Procedure)
sp_MSgetconflicttablename (Procedure)
sp_MSgettrancftsrcrow (Procedure)
sp_MSget_publisher_rpc (Procedure)
sp_MSget_qualified_name (Procedure)
sp_MShelpcolumns (Procedure)
sp_MShelpconflictpublications (Procedure)
sp_MShelpfulltextscript (Procedure)
sp_MShelpmergearticles_nonpartgroups (Procedure)
sp_MShelpmergeconflictcounts (Procedure)
sp_MShelpmergeschemaarticles (Procedure)
sp_MShelpmergeselectarticles (Procedure)
sp_MShelptranconflictpublications (Procedure)
sp_MShelptype (Procedure)
sp_MShelp_distdb (Procedure)
sp_MShelp_identity_property (Procedure)
sp_MShelp_replication_table (Procedure)
sp_MSindexspace (Procedure)
sp_MSisallreplcolpk (Procedure)
sp_MSiscolpk (Procedure)
sp_MSisdynamicfunction (Procedure)
sp_MSlocktable (Procedure)
sp_MSmakearticleprocs (Procedure)
sp_MSmakebatchinsertproc (Procedure)
sp_MSmakeconflictinsertproc (Procedure)
sp_MSmakeconflicttable (Procedure)
sp_MSmakectsview (Procedure)
sp_MSmakedynsnapshotvws (Procedure)
sp_MSmakeexpandproc (Procedure)
sp_MSmakepeerconflicttable (Procedure)
sp_MSmakeselectproc (Procedure)
sp_MSmaketrancftproc (Procedure)
sp_MSmergepublishdb (Procedure)
sp_MSmerge_altertrigger (Procedure)
sp_MSmerge_ddldispatcher (Procedure)
sp_MSmerge_upgrade_subscriber (Procedure)
sp_MSobjectprivs (Procedure)
sp_MSpostapplyscript_forsubscriberprocs (Procedure)
sp_MSpublicationview (Procedure)
sp_MSpublishdb (Procedure)
sp_MSreenable_check (Procedure)
sp_MSrefresh_idrange_check_constraint (Procedure)
sp_MSregenerate_mergetriggers (Procedure)
sp_MSremovedbreplication (Procedure)
sp_MSremovedb_merge_replication_brute_force (Procedure)
sp_MSremoveidrangesupport (Procedure)
sp_MSreplcheck_permission (Procedure)
sp_MSreplicationcompatlevel (Procedure)
sp_MSreplsup_table_has_pk (Procedure)
sp_MSrepltrigpreparecert (Procedure)
sp_MSrepltrigredefine (Procedure)
sp_MSrepl_addarticle (Procedure)
sp_MSrepl_adddistpublisher (Procedure)
sp_MSrepl_addpublication (Procedure)
sp_MSrepl_addsubscription (Procedure)
sp_MSrepl_articlefilter (Procedure)
sp_MSrepl_articleview (Procedure)
sp_MSrepl_browsesnapshotfolder (Procedure)
sp_MSrepl_changearticle (Procedure)
sp_MSrepl_changesubstatus (Procedure)
sp_MSrepl_droparticle (Procedure)
sp_MSrepl_droppublication (Procedure)
sp_MSrepl_get_Oracle_publisher_metadata (Procedure)
sp_MSrepl_GrantSelectOnMergeSystemTables (Procedure)
sp_MSrepl_helparticle (Procedure)
sp_MSrepl_IsUserInAnyPAL (Procedure)
sp_MSrepl_refresh_heterogeneous_publisher (Procedure)
sp_MSrepl_schema (Procedure)
sp_MSrepl_startup_internal (Procedure)
sp_MSrepl_testconnection (Procedure)
sp_MSreseed (Procedure)
sp_MSResetTriggerProcs (Procedure)
sp_MSreset_queue (Procedure)
sp_MSrestoredbreplication (Procedure)
sp_MSscriptsubscriberprocs (Procedure)
sp_MSscript_article_view (Procedure)
sp_MSscript_compensating_insert (Procedure)
sp_MSsendtosqlqueue (Procedure)
sp_MSsetartprocs (Procedure)
sp_MSsetconflicttable (Procedure)
sp_MSsetfilteredstatus (Procedure)
sp_MSsetfilterparent (Procedure)
sp_MSsetupnosyncsubwithlsnatdist (Procedure)
sp_MSsetup_partition_groups_table (Procedure)
sp_MSsub_cleanup_orphans (Procedure)
sp_MStablekeys (Procedure)
sp_MStablenamefromnick (Procedure)
sp_MStablenickname (Procedure)
sp_MStablerefs (Procedure)
sp_MStablespace (Procedure)
sp_MStran_altertable (Procedure)
sp_MStran_altertrigger (Procedure)
sp_MStran_ddlrepl (Procedure)
sp_MSuniquename (Procedure)
sp_MSuniqueobjectname (Procedure)
sp_MSuniquetempname (Procedure)
sp_MSunmarkreplinfo (Procedure)
sp_MSupdategenerations_afterbcp (Procedure)
sp_MSupdatesysmergearticles (Procedure)
sp_MSUpgradeConflictTable (Procedure)
sp_MSvalidatearticle (Procedure)
sp_MSverboselogging (Procedure)
sp_MS_marksystemobject (Procedure)
sp_objectfilegroup (Procedure)
sp_ORAdroppublisher (Procedure)
sp_ORAverifypublisher (Procedure)
sp_peerconflictdetection_tableaug (Procedure)
sp_pkeys (Procedure)
sp_procoption (Procedure)
sp_refreshsqlmodule (Procedure)
sp_refreshsqlmodule_internal (Procedure)
sp_rename (Procedure)
sp_repladdcolumn (Procedure)
sp_repldropcolumn (Procedure)
sp_replqueuemonitor (Procedure)
sp_replsqlqgetrows (Procedure)
sp_restoredbreplication (Procedure)
sp_schemata_rowset (Procedure)
sp_scriptdelproccore (Procedure)
sp_scriptinsproccore (Procedure)
sp_scriptupdmoderefresh (Procedure)
sp_scriptupdproccore (Procedure)
sp_setreplfailovermode (Procedure)
sp_settriggerorder (Procedure)
sp_showrowreplicainfo (Procedure)
sp_spaceused (Procedure)
sp_statistics (Procedure)
sp_statistics_100 (Procedure)
sp_statistics_rowset (Procedure)
sp_statistics_rowset2 (Procedure)
sp_stored_procedures (Procedure)
sp_subscription_cleanup (Procedure)
sp_sysdac_rollback_all_pending_objects (Procedure)
sp_syspolicy_dispatch_event (Procedure)
sp_syspolicy_mark_system (Procedure)
sp_sysutility_ucp_configure_policies (Procedure)
sp_sysutility_ucp_initialize_mdw (Procedure)
sp_sysutility_ucp_provision_utility_object_internal (Procedure)
sp_sysutility_ucp_recreate_synonym_internal (Procedure)
sp_sysutility_ucp_remove (Procedure)
sp_tables (Procedure)
sp_table_constraints_rowset (Procedure)
sp_table_constraints_rowset2 (Procedure)
sp_table_statistics2_rowset (Procedure)
sp_unbindefault (Procedure)
sp_unbindrule (Procedure)
sp_unlink_publication (Procedure)
sp_unlink_publication_internal (Procedure)
sp_updatestats (Procedure)
sp_vupgrade_distdb (Procedure)
sp_vupgrade_heterogeneous_publishers (Procedure)
sp_vupgrade_mergeobjects (Procedure)
sp_vupgrade_mergetables (Procedure)
sp_vupgrade_publisherdb (Procedure)
sp_vupgrade_replication (Procedure)
sp_vupgrade_replmsdb (Procedure)
sp_vupgrade_replsecurity_metadata (Procedure)
sp_vupgrade_subscription_tables (Procedure)
synonyms (View)
syscacheobjects (View)
sysconstraints (View)
sysobjects (View)
system_objects (View)
system_objects$ (View)
system_sql_modules (View)
system_views (View)
tables (View)
TABLE_CONSTRAINTS (View)
TABLE_PRIVILEGES (View)
views (View)
VIEW_COLUMN_USAGE (View)
VIEW_TABLE_USAGE (View)
       



News

  Query a named instance
Sybase+ASE+silent+install
SQL 2008 R2
Deprecated procedures in SQL2008
Reporting Services item-level role definitions
Create all your missing indexes
Converting datetime field
Start MSSQL Server Profiler at time
Replicating MSSQL Server views
Exploring Microsoft Sharepoint
The OLE DB provider "SQLNCLI10" for linked server indicates.
Mobile solar charger
Oracle to SQL Server replication
Cannot insert the value NULL into column
Undocumented Microsoft SQL Server 2008
VMware
Zoekmachine optimalisatie
SQL Servers hidden objects
FckEditor
Flash in Ajax
De hype die AJAX heet
Barcode scannen
MySQL; Gratis, makkelijk en snel!
PHP
sIFR; de combinatie tussen HTML en Flash