达梦查询数据库和表是否存在

达梦查询数据库是否存在：select COUNT(1) from sysobjects where NAME=‘DB1’ and SUBTYPE$ is null达梦查询数据库表是否存在：select COUNT(1) from dba_segments where dba_segments.OWNER=‘DB1’ and SEGMENT_NAME=‘table1’

--勇

5233人浏览 · 2020-12-07 19:38:27

--勇 · 2020-12-07 19:38:27 发布

达梦查询数据库是否存在：
select COUNT(1) from sysobjects where NAME=‘DB1’ and SUBTYPE$ is null
达梦查询数据库表是否存在：
select COUNT(1) from dba_segments where dba_segments.OWNER=‘DB1’ and SEGMENT_NAME=‘table1’