SQL·高级查询

--查看所有的数据库信息&＃xff1b;
select * from master..sysdatabases
exec sp_helpdb

--查看某数据库中的所有用户表&＃xff1b;
select name from northwind..sysobjects where xtype&＃61;&＃39;u&＃39;

--查询某表中所有列名&＃xff1b;
select name from syscolumns where id&＃61;object_id(&＃39;news&＃39;)

--查看某触发器SQL脚本代码&＃xff1b;

select text from syscomments where id&＃61;object_id(&＃39;NS&＃39;)

exec sp_helptext &＃39;NS&＃39;

--查看某数据库的具体情况&＃xff1b;
select * from sysfiles
exec sp_spaceused
exec sp_helpdb &＃39;NewsSystem&＃39;

--查看某表的完整结构&＃xff1b;
exec sp_help &＃39;news&＃39;

exec sp_msforeachtable