达梦查询数据库是否存在:
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-07-29 15:22:37 发布
达梦查询数据库是否存在:
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’