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'

posted @ 2022-11-04 15:17  阿小ZY  阅读(182)  评论(0)    收藏  举报