sys.objects catalog view contains a row for each object in the database. : sys.objects « System Tables Views

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

1.	Query
2.	Insert Delete Update
3.	Table
4.	Table Join
5.	Data Types
6.	Set Operations
7.	Constraints
8.	Subquery
9.	Aggregate Functions
10.	Date Functions
11.	Math Functions
12.	String Functions
13.	Data Convert Functions
14.	Analytical Functions
15.	Sequence Indentity
16.	View
17.	Index
18.	Cursor
19.	Database
20.	Transact SQL
21.	Procedure Function
22.	Trigger
23.	Transaction
24.	XML
25.	System Functions
26.	System Settings
27.	System Tables Views
28.	User Role
29.	CLR

Java

Java Tutorial

Java Source Code / Java Documentation

Illustrator Tutorials

GIMP Tutorials

C# / C Sharp

C# / CSharp Tutorial

C# / CSharp Open Source

Oracle PL/SQL Tutorial

Flash / Flex / ActionScript

VBA / Excel / Access / Word

XML

XML Tutorial

Microsoft Office PowerPoint 2007 Tutorial

Microsoft Office Excel 2007 Tutorial

Microsoft Office Word 2007 Tutorial

SQL Server / T-SQL Tutorial » System Tables Views » sys.objects

27. 10. 3. 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)

27. 10. sys.objects
	27. 10. 1.	Query sys.objects for object name
	27. 10. 2.	sys.objects INNER JOIN sys.columns
	27. 10. 3.	sys.objects catalog view contains a row for each object in the database.
	27. 10. 4.	Getting Details about User-Defined Functions in master

www.java2java.com | Contact Us

All other trademarks are property of their respective owners.