达梦查询数据库是否存在:
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’
达梦查询数据库和表是否存在
最新推荐文章于 2024-06-27 18:07:59 发布
达梦查询数据库是否存在:
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’