判断数据库表是否存在

By xbingo 2022年6月17日

1、Mysql

SELECT COUNT(*) FROM information_schema.TABLES WHERE table_name ='表名' AND TABLE_SCHEMA = (select DATABASE()) AND TABLE_TYPE = 'BASE TABLE';

select count(*) from user_tables where table_name =upper('表名')

select count(*) from sysobjects where id = object_id('表名') and OBJECTPROPERTY(id, N'IsUserTable') = 1