sql server2005过系统表查出数据表的字段名称字段类型和字段长度
select syscolumns.name as ColumnsName,SysTypes.name as DataType,SysColumns.Length as DataLengthfrom syscolumns inner join sysobjects on syscolumns.id=sysobjects.idinner join SysTypes on Syscolum
原创
2009-08-21 17:30:00 ·
556 阅读 ·
0 评论