2012年5月15日
获取MSSQL中表名、列名、字段类型、长度
摘要： View Code 1 select syscolumns.name AS ColumnName,systypes.name AS TypeName,syscolumns.length as length2 from syscolumns,sysobjects,systypes where syscolumns.id=sysobjects.id and syscolumns.xtype= systypes.xtype and sysobjects.name= '表名' order by syscolumns.colid1 select * from sys.all_column 阅读全文
posted @ 2012-05-15 11:27 划破黑夜 阅读(959) 评论(0) 推荐(1)