Sql 查询库、表、列名的语句

 

查询库名
Select Name FROM Master..SysDatabases order by Name

查询News库的所有表名
Select Name from News..sysobjects where xtype='u' order by name

查询T_News_Class表的所有字段名 及字段类型
select column_name,data_type from information_schema.columns where table_name  ='T_News_Class'