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)