SQL SERVER 列出所有資料表(Table)

列出所有資料表(Table)

USE YourDBName
GO 
SELECT *
FROM sys.Tables
GO 

列出所有檢視表(View)

SELECT *
FROM sys.views
GO 

列出所有預存程式(Stored Procedure)

SELECT *
FROM sys.procedures;

列出所有限制(Constraint)

SELECT * FROM sys.objects
WHERE type_desc LIKE ‘%CONSTRAINT’