Mega Code Archive

 

Categories / MSSQL Tutorial / System Tables Views

 

Sysobjects contains a row for each database object

type    The type of a database object. Can be one of the following strings: C = check constraint; D = default; F = foreign key constraint; L = transaction log; P = stored procedure; K = primary key or unique constraint; R rule; RF = replication stored procedure; S = system table; TR = trigger; U = user table; V = view; X = extended stored procedure 21> select  top 10 * from sysobjects; 22> GO name                                                                                                                             id          xtype uid    info   status      base_schema_ver replinfo  parent_obj  crdate                  ftcatid schema_ver  stats_schema_ver type userstat sysstat indexdel refdate                 version     deltrig     instrig     updtrig     seltrig     category  cache -------------------------------------------------------------------------------------------------------------------------------- ----------- ----- ------ ------ ----------- --------------- -----------  ----------- ----------------------- ------- ----------- ---------------- ---- -------- ------- -------- ----------------------- ----------- ----------- ----------- ----------- ----------- -----------  ------ sysrowsetcolumns                                                                                                                           4 S          4      0           0               0           0            0 2005-10-14 01:36:06.707       0           0                0 S           1       1        0 2005-10-14 01:36:06.707           0           0           0           0           0           2       0 sysrowsets                                                                                                                                 5 S          4      0           0               0           0            0 2005-10-14 01:36:06.690       0           0                0 S           1       1        0 2005-10-14 01:36:06.690           0           0           0           0           0           2       0 sysallocunits                                                                                                                              7 S          4      0           0               0           0            0 2005-10-14 01:36:06.690       0           0                0 S           1       1        0 2005-10-14 01:36:06.690           0           0           0           0           0           2       0 sysfiles1                                                                                                                                  8 S          4      0           0               0           0            0 2003-04-08 09:13:37.267       0           0                0 S           1       1        0 2003-04-08 09:13:37.267           0           0           0           0           0           2       0 syshobtcolumns                                                                                                                            13 S          4      0           0               0           0            0 2005-10-14 01:36:06.707       0           0                0 S           1       1        0 2005-10-14 01:36:06.707           0           0           0           0           0           2       0 syshobts                                                                                                                                  15 S          4      0           0               0           0            0 2005-10-14 01:36:06.707       0           0                0 S           1       1        0 2005-10-14 01:36:06.707           0           0           0           0           0           2       0 sysftinds                                                                                                                                 25 S          4      0           0               0           0            0 2005-10-14 01:36:06.877       0           0                0 S           1       1        0 2005-10-14 01:36:06.877           0           0           0           0           0           2       0 sysserefs                                                                                                                                 26 S          4      0           0               0           0            0 2005-10-14 01:36:06.720       0           0                0 S           1       1        0 2005-10-14 01:36:06.720           0           0           0           0           0           2       0 sysowners                                                                                                                                 27 S          4      0           0               0           0            0 2005-10-14 01:36:06.863       0           0                0 S           1       1        0 2005-10-14 01:36:06.863           0           0           0           0           0           2       0 sysdbreg                                                                                                                                  28 S          4      0           0               0           0            0 2005-10-14 01:36:06.737       0           0                0 S           1       1        0 2005-10-14 01:36:06.737           0           0           0           0           0           2       0 (10 rows affected)