SQL Server 2000 中查询表结构

 Select 
    col.[name]  as '字段名',
    col.[length]as '长度'  ,
    type.[name] as '类型'  ,
    pro.value   as '描述'  
 From syscolumns as col
 Left Join systypes as type on col.xtype = type.xtype
 Left Join sysProperties as pro on col.id = pro.id and col.colid = pro.smallid
 where col.id = (Select id From Sysobjects Where name = 'tableName')

转载于:https://www.cnblogs.com/chongchong1982/archive/2007/12/28/1018317.html