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, 1260🔥, 0💬
Popular Posts:
How to generate test credit card numbers? Test credit card numbers are frequently needed in testing ...
How to generate currency test values? Currency test values are frequently needed in testing date and...
How to generate user full names? Test user names are frequently needed in testing applications that ...
Where to find online test tools? FYIcenter.com has prepared a number of online test tools: Data Look...
How to perform regular expression pattern match with multiple occurrences? To perform a regular expr...