查询当前实例上有哪些数据库:
SELECT name FROM Master.dbo.SysDatabases ORDER BY name;
查询有哪些用户表:
SELECT name FROM SysObjects Where XType='U' ORDER BY name;
--或者直接:
SELECT * from sys.tables;
查询有哪些系统表:
SELECT name FROM SysObjects Where XType='S' ORDER BY name;
查询所有表:
SELECT name FROM SysObjects ORDER BY name;
--或者直接调用存储过程:
exec sp_tables;
查询有哪些列:
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='subject';
--或者:
SELECT name FROM SysColumns Where id=Object_Id('TableName');