テーブルが存在しているか確認するSQLです。
PostgreSQL/Redshift
SELECT * FROM information_schema.tables WHERE table_name = 'table_name';
Oracle
SELECT owner,table_name FROM dba_tables WHERE table_name = 'table_name';
More than 5 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme