sql获取表结构

SELECT a.name 字段名, (case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then 1 ELSE 0 end) 标识, (case when (SELECT count(*) FROM dbo.sysobjects WHERE (name in ...
posted @ 2018-08-13 17:22  递龟  阅读(2823)  评论(0)  编辑  收藏  举报