Sql

Search

check if table exists oracle

SELECT * FROM USER_TABLES WHERE TABLE_NAME = 'my_table';
-- Tables from schemes you can access
SELECT * FROM ALL_TABLES WHERE OWNER = 'scheme_name' TABLE_NAME = 'my_table';
-- Tables from schemes you can access
SELECT * FROM DBA_TABLES WHERE OWNER = 'scheme_name' TABLE_NAME = 'my_table';

Comment

PREVIOUS	NEXT

Code Example
Sql :: SQL date part only of datetime
Sql :: set nocount on sql
Sql :: table or view does not exist
Sql :: sql server pagination limit
Sql :: sqlite create table if not exists
Sql :: select index table oracle
Sql :: mysql update row
Sql :: sql server update column based on another table
Sql :: mysql version query
Sql :: sql server: difference between hashtable and table declared using declare keyword
Sql :: oracle drop index if exists
Sql :: postgresql to_char time
Sql :: get server date mysql
Sql :: sql duplicate rows
Sql :: show all database inside postgresql
Sql :: import large .sql files into lampp
Sql :: copy table in mysql with data
Sql :: date_part mysql
Sql :: replace string value in sql
Sql :: show all tables postgres
Sql :: DROP TABLes regardless of constraints
Sql :: mysql change password
Sql :: mysql check datetime equals date
Sql :: mysql replace string in table
Sql :: join in update query in mysql
Sql :: mysql store ip address
Sql :: import mysql dump command line
Sql :: mysql copy table to another table
Sql :: mysql select true or false
Sql :: postgresql combine values in one field

Search

SQL

check if table exists oracle

ADD CONTENT