select a.name,a.system_type_id as type,
cast(isnull(e.[value],'') as nvarchar(100)) as remark
from sys.columns a inner join sys.objects c on a.object_id=c.object_id and c.type='u'
left join sys.extended_properties e on e.major_id=c.object_id
and e.minor_id=a.column_id
and e.class=1
where c.name='dbo.Admin'
使用这个SQL怎么查询出来结果为空,使用的是MSSQL数据库
- 写回答
- 好问题 0 提建议
- 关注问题
- 邀请回答
-