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, 1273🔥, 0💬
Popular Posts:
How to call JMeter command in a Windows batch file? I want to create a single batch job to run JMete...
In what order thread groups are executed in JMeter? Thread groups, including regular "Thread Groups"...
Where to find online test tools? FYIcenter.com has prepared a number of online test tools: Data Look...
Where to find online test tools? FYIcenter.com has prepared a number of online test tools: Data Look...
How to see my IP address Host Name? To help you to see your IP Address Host Name, FYIcenter.com has ...