sql server查询表名
select * from information_schema.tables where TABLE_CATALOG='Eca_SysDb_JLDQ';(包含视图)
select table_name from information_schema.tables where TABLE_CATALOG='Eca_SysDb_JLDQ' and table_type = 'BASE TABLE'
select * from information_schema.tables where TABLE_CATALOG='Eca_SysDb_JLDQ';(包含视图)
select table_name from information_schema.tables where TABLE_CATALOG='Eca_SysDb_JLDQ' and table_type = 'BASE TABLE'