Sql Server根据数据库的某个字段查询到它所在的表
select name from sys.objects a where object_id in(select object_id from sys.columns where name='bankaccount');
**bankaccount**
为需要查询的字段;
select name from sys.objects a where object_id in(select object_id from sys.columns where name='bankaccount');
**bankaccount**
为需要查询的字段;