Một số đối tượng hệ thống của SQL server

SELECT * FROM sys.databases

SELECT * FROM sys.master_files

SELECT * FROM sys.database_files

SELECT * FROM sys.data_spaces

SELECT * FROM sys.login_token

SELECT * FROM sys.server_principals

SELECT * FROM sys.sql_logins

SELECT * FROm sys.objects

SELECT * FROM sys.procedures

SELECT * FROM sys.columns

SELECT * FROM sys.columns WHERE object_id = object_id('ct00')

SELECT * FROM sys.Tables

SELECT * FROM sys.triggers

SELECT * FROM sys.servers

SELECT * FROM sys.identity_columns

SELECT * FROM sys.default_constraints

SELECT * FROM sys.check_constraints

SELECT * FROM sys.key_constraints --PRIMARY KEY Constraints, UNIQUE Constraints

SELECT * FROM sys.foreign_keys

Select * FROM sys.Types

SELECT * FROm sys.indexes

SELECT * FROM sys.index_columns

SELECT * FROM sys.sql_dependencies

SELECT * FROM sys.sql_dependencies

SELECT * FROm sys.objects WHERE type IN ('FN', 'IF', 'TF');

Select * FROM INFORMATION_SCHEMA.COLUMNS

Select * FROM INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE