- 獲取當前資料庫所有使用者表
SELECT name FROM sysobjects WHERE xtype = 'U' AND status >= 0;
- 獲取指定表所有欄位名
SELECT name FROM syscolumns WHERE id = OBJECT_ID('表名');
- 查看與某表相關的視圖、存儲過程、函數
SELECT a.* FROM sysobjects a, syscomments b
WHERE a.id = b.id AND b.text LIKE '%表名%';
- 列出當前資料庫所有存儲過程
SELECT name AS 存儲過程名稱 FROM sysobjects WHERE xtype = 'P';
- 查詢使用者建立的所有資料庫 (排除 sa)
SELECT * FROM master..sysdatabases d
WHERE sid NOT IN (SELECT sid FROM master..syslogins WHERE name = 'sa');
-- 或
SELECT dbid, name AS DB_NAME FROM master..sysdatabases WHERE sid <> 0x01;
- 查詢某表欄位與資料類型
SELECT column_name, data_type
FROM information_schema.columns
WHERE table_name = '表名';