sys.objects catalog view contains a row for each object in the database. : sys.objects « System Tables Views « SQL Server / T-SQL Tutorial
- SQL Server / T-SQL Tutorial
- System Tables Views
- sys.objects
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)