查询数据库、表名称、表字段

 1 查询数据库名：
 2 use master ;select * from sysdatabases where dbid>4
 3 查询表名:
 4 SELECT * FROM SysObjects Where XType='U' ORDER BY Name 
 5 查询表中字段、长度、类型
 6 select b.name as 表名,a.name as 字段名,c.name as 数据类型,a.length as 长度
 7 from syscolumns a
 8 inner join sysobjects b on a.id=b.id
 9 inner join systypes c on a.xtype=c.xtype
10 WHERE a.id=OBJECT_ID(N'[表名称]') ORDER BY colid
【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/xyzhuzhou/p/3319016.html