Collections:
What Is sys.objects
What Is sys.objects view in SQL Server?
✍: FYIcenter.com
sys.objects is a system view in a SQL Server Database
that contains information about each data object like a table or an index
used by the database.
Each record in the sys.objects table represents a single data object with the following key fields:
Here is a list of records from sys.objects showing different types of data objects in a SQL Server database:
SELECT * FROM sys.objects name object_id schema_id type type_desc ... ORDER_USER_ID 44648 1 F FOREIGN_KEY_CONSTRAINT ... sqlagent_jobs 211197 4 IT INTERNAL_TABLE ... INVOICE_PK 5670 1 PK PRIMARY_KEY_CONSTRAINT ... ORDER_ID 56668 1 SO SEQUENCE_OBJECT ... GET_ZIP 28652 1 FN SQL_SCALAR_FUNCTION ... archive_user 19062 1 P SQL_STORED_PROCEDURE ... USER_NEW 28662 1 TR SQL_TRIGGER ... sysdbfiles 20 4 S SYSTEM_TABLE ... ADDRESS 2115 1 U USER_TABLE ...
⇐ List All Files in a Filegroup
2019-07-09, 1662🔥, 0💬
Popular Posts:
How to use HTTP protocol to post an XML message to a server? You can follow this tutorial to post an...
Where to find online test tools? FYIcenter.com has prepared a number of online test tools: Data Look...
How to turn on Chrome WebDriver logging with Selenium Python API? If you want to turn on logging on ...
How to convert hexadecimal encoded data back to binary data (or Hex to Binary Decoding)? Hex to Bina...
How to perform UUDecode (Unix-to-Unix Decode)? UUEncode is Unix-to-Unix encoding used on Unix system...