将SQL Server中所有表的列信息显示出来--打印文章

将SQL Server中所有表的列信息显示出来

作者：武汉SEO闵涛文章来源：敏韬网点击数2621 更新时间：2007/11/14 13:07:14 文章录入：mintao 责任编辑：mintao

On (Syscolumns.Id = Sysproperties.Id And
16

Syscolumns.Colid = Sysproperties.Smallid)
17

Where (Sysobjects.Xtype =''''U'''' Or Sysobjects.Xtype =''''V'''')
19

And Sysobjects.Id = Syscolumns.Id And Systypes.Xtype = Syscolumns.Xtype
20

And Systypes.Name <> ''''Sysname'''' And Sysobjects.Name Like ''''%'''' Order By Sysobjects.Name, Syscolumns.Colid
结果如图：

Click to Open in New Window