sql 查询所有数据库、表名、表字段总结

查询所有表：

select id,name from sysobjects where type= 'u' order by name

查询所有数据库：

use master 
select name from sysdatabases order by name

查询表中所有字段：

select name from syscolumns where id = 
(select id from sysobjects where type = 'u' and name = '表名')