列名 total 无效
但不知道这个total字段究竟是在哪张表中的,表太多有上百张,有办法查询吗?
2 个解决方案
#1
select sys.objects.name,* from sys.columns
inner join sys.objects on sys.columns.object_id = sys.objects.object_id
where sys.columns.name = '列名'
inner join sys.objects on sys.columns.object_id = sys.objects.object_id
where sys.columns.name = '列名'
#2
测试了,能用,好用,谢谢啊!
#1
select sys.objects.name,* from sys.columns
inner join sys.objects on sys.columns.object_id = sys.objects.object_id
where sys.columns.name = '列名'
inner join sys.objects on sys.columns.object_id = sys.objects.object_id
where sys.columns.name = '列名'
#2
测试了,能用,好用,谢谢啊!