時機律動來往間

顯示特定資料表的所有欄位名稱
SELECT B.NAME  FROM SYSOBJECTS AS A, SYSCOLUMNS AS B WHERE A.XTYPE = 'U' AND A.ID = B.ID AND A.NAME='TableName';
SELECT ORDINAL_POSITION,COLUMN_NAME,DATA_TYPE,CHARACTER_MAXIMUM_LENGTH,IS_NULLABLE,COLUMN_DEFAULT FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='TableName' ORDER BY ORDINAL_POSITION ASC;
EXEC SP_COLUMNS TableName;

取得資料庫所有資料表名稱
SELECT * FROM SYSOBJECTS WHERE XTYPE = 'U';

伺服器各資料庫的名稱
SELECT NAME FROM MASTER.DBO.SYSDATABASES;

資料表及檢視表名稱
SELECT Table_name FROM INFORMATION_SCHEMA.TABLES ORDER BY Table_name;


找資料表的PK欄位
SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE TABLE_NAME = 'TableName';