SQL Server 查询元数据

SELECT
NAME,SCHEMA_NAME(SCHEMA_ID)
FROM sys.tables

SELECT
name,TYPE_NAME(SYSTEM_type_id),max_length,collation_name,is_nullable
FROM sys.columns
WHERE [object_id]=OBJECT_ID('dbo.hr_staff')

SELECT * FROM information_schema.tables
SELECT * FROM information_schema.[COLUMNS] AS c

EXEC sp_tables
EXEC sys.sp_helpconstraint @objname=N'dbo.HR_STAFF'

转载于:https://www.cnblogs.com/randy-fu/p/11468394.html