2010年4月2日
sql 2005 跟据视图名列出视图所有列的描述
摘要： select vcu.view_name,tbd.* from (select tmp.tablename,tmp.columnname,ep.* from sys.extended_properties ep join (select tb.name as tablename, cl.object_id,cl.name as columnname,cl.column_id from sys.co... 阅读全文
posted @ 2010-04-02 13:48 heshangwen 阅读(917) 评论(0) 推荐(0)
sql 2005 返回列描述的SQL语句
摘要： select tmp.tablename,ep.* from sys.extended_properties ep join (select tb.name as tablename, cl.object_id,cl.name as columnname,cl.column_id from sys.columns cl join(select name,object_id from sys.tab... 阅读全文
posted @ 2010-04-02 09:47 heshangwen 阅读(856) 评论(0) 推荐(0)