Mega Code Archive

 

Categories / MSSQL Tutorial / System Tables Views

 

Sys objects catalog view contains a row for each object in the database

5> 6> select  top 10 * from sys.objects; 7> GO 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 -------------------------------------------------------------------------------------------------------------------------------- ----------- ------------ ----------- ---------------- ---- ------------ ------------------------------------------------ ----------------------- ----------------------- ------------- ------------ ------------------- sysrowsetcolumns                                                                                                                           4         NULL           4                0 S    SYSTEM_TABLE                                                  2005-10-14 01:36:06.707 2005-10-14 01:36:06.707             1            0                   0 sysrowsets                                                                                                                                 5         NULL           4                0 S    SYSTEM_TABLE                                                  2005-10-14 01:36:06.690 2005-10-14 01:36:06.690             1            0                   0 sysallocunits                                                                                                                              7         NULL           4                0 S    SYSTEM_TABLE                                                  2005-10-14 01:36:06.690 2005-10-14 01:36:06.690             1            0                   0 sysfiles1                                                                                                                                  8         NULL           4                0 S    SYSTEM_TABLE                                                  2003-04-08 09:13:37.267 2003-04-08 09:13:37.267             1            0                   0 syshobtcolumns                                                                                                                            13         NULL           4                0 S    SYSTEM_TABLE                                                  2005-10-14 01:36:06.707 2005-10-14 01:36:06.707             1            0                   0 syshobts                                                                                                                                  15         NULL           4                0 S    SYSTEM_TABLE                                                  2005-10-14 01:36:06.707 2005-10-14 01:36:06.707             1            0                   0 sysftinds                                                                                                                                 25         NULL           4                0 S    SYSTEM_TABLE                                                  2005-10-14 01:36:06.877 2005-10-14 01:36:06.877             1            0                   0 sysserefs                                                                                                                                 26         NULL           4                0 S    SYSTEM_TABLE                                                  2005-10-14 01:36:06.720 2005-10-14 01:36:06.720             1            0                   0 sysowners                                                                                                                                 27         NULL           4                0 S    SYSTEM_TABLE                                                  2005-10-14 01:36:06.863 2005-10-14 01:36:06.863             1            0                   0 sysdbreg                                                                                                                                  28         NULL           4                0 S    SYSTEM_TABLE                                                  2005-10-14 01:36:06.737 2005-10-14 01:36:06.737             1            0                   0 (10 rows affected)