读取sqlserver数据库以及表的信息

--sql server 查询所有表及表字段的列、类型长度等
select dbo.sysobjects.name as Table_name,
dbo.syscolumns.name as Column_name,
dbo.systypes.name as Type_name,
dbo.systypes.length as Type_length,
columnproperty(dbo.syscolumns.id,dbo.syscolumns.name,'precision') as Column_lengh
from dbo.syscolumns inner join dbo.sysobjects
on dbo.syscolumns.id = dbo.sysobjects.id
left join dbo.systypes
on dbo.syscolumns.xtype = dbo.systypes.xusertype
where dbo.sysobjects.name = '替换为表名'
and (dbo.sysobjects.xtype = 'u')
and (not (dbo.sysobjects.name like 'dtproperties'))
---------------------------------------------------------------------
--查询数据库所有表
select name from dbo.sysobjects where xtype='u' and (not name like 'dtproperties') order by name