随笔分类 -  MSSQL

 
根据表名查找相应表结构
摘要:SELECT'表名' =case when a.colorder=1 then d.name else''end,'表说明'=case when a.colorder=1 then isnull(f.value,'') else''end,'字段序号' = a.colorder,'字段名' = a.name,'标识' =case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then '√&# 阅读全文
posted @ 2012-06-29 15:43 xunmengzhi 阅读(203) 评论(0) 推荐(0)