csharpcherry

列出所有資料表(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’

----SQL SERVER 2005 System Procedures EXEC sp_databases EXEC sp_helpdb ----SQL 2000 Method still works in SQL Server 2005 SELECT name FROM sys.databases SELECT name FROM sys.sysdatabases

中國微軟為Visual Studio 2010 宣傳所做的廣告 VS2010 做你下一行的 Code VS2010 讓愛延長 VS2010 幸福要敏捷 VS2010 為愛 Debug VS2010 讓愛編譯通過