如何才知道一个表是否存在在数据库里？

[hzai]

谢谢！

[bzszp]

select count(*) from dba_tables where TABLE_NAME='TABLENAME';
返回大于零则存在

[bzszp]

如果是查在某用户下是否有此表,则
select count(*) from CAT where TABLE_NAME='TABLENAME';

[csdnyork]

select * from cat where ;
select * from tab where ;
select * from user_tables where ;

[jiezhi]

select count(*) from user_objects where object_name='table1';

[13312933476]

很简单呀!
命令行方式下输入:desc tablename

[xiapb]

select * from all_objects where upper(object_name) = 'TABLENAME' and object_type = 'TABLE'

[feihong_xue]

select * from all_tables where table_name='TABLENAME'
注意表名要用大写！

[luckysxn]

up