In Oracle select count(table_name) from all_tables where table_name = 'TABLE'
例: if exists(select 1 from sys.systable where table_name='SPAREPART' and table_type='BASE') then drop table SPAREPART end if;
select * from dba_tables where table_name = 'YOUR_TABLE_NAME';或者select * from all_tables where table_name = 'YOUR_TABLE_NAME';或者select * from user_tables where table_name = 'YOUR_TABLE_NAME';
select tname from tab where tname = '<tablename>'
查询数据字典,select count(*) from all_tables where table_name='your_talbe_name'
select count(table_name) from all_tables where table_name = 'TABLE'
if exists(select 1 from sys.systable where table_name='SPAREPART' and table_type='BASE') then
drop table SPAREPART
end if;
where table_name = 'YOUR_TABLE_NAME';或者select * from all_tables
where table_name = 'YOUR_TABLE_NAME';或者select * from user_tables
where table_name = 'YOUR_TABLE_NAME';