SQL查数据库表,字段
摘要:
//查表select name from sysobjects where xtype='u'//查列select c.name as cname,t.name as [type],c.max_length as [length],(select value from sys.extended_properties as ex where ex.major_id = c.object_id and ex.minor_id = c.column_id) as notes from sys.columns as c inner join sys.tables as ta on c. 阅读全文
posted @ 2011-12-15 16:19
飞舞的蒲公英
阅读(223)
评论(0)
推荐(0)