Search
 
SCRIPT & CODE EXAMPLE
 

SQL

oracle get table schema

SELECT * FROM USER_TABLES;		-- Tables from connected schema
SELECT * FROM ALL_TABLES;		-- Tables available to connected schema
	SELECT * FROM ALL_TABLES WHERE OWNER = 'SCHEMA_NAME';
	SELECT * FROM ALL_TABLES WHERE TABLE_NAME = 'TABLE_NAME';
SELECT * FROM DBA_TABLES;		-- All database Tables
Comment

PREVIOUS NEXT
Code Example
Sql :: how to truncate table with foreign key constraint 
Sql :: redshift running queries 
Sql :: apex execute batch job 
Sql :: sql ignore accents 
Sql :: start postgresql 
Sql :: SQL order random 
Sql :: finding last created table mysql 
Sql :: mysql alter table add index 
Sql :: return names of columns in table sql 
Sql :: mysql list databases 
Sql :: how to edit table name in mysql 
Sql :: postgres kill running query 
Sql :: sqlite alter table add column 
Sql :: oracle to_timestamp 
Sql :: restart postgresql.service Failed to restart postgresql.service: Unit not found. 
Sql :: sqlite rename column 
Sql :: select users 
Sql :: mysql 1 day ago 
Sql :: sql auto update dupdated_at 
Sql :: alter table engine mysql 
Sql :: sql between date range 
Sql :: oracle list dblink 
Sql :: mysql concat two columns laravel eloquent 
Sql :: how to list function in psql 
Sql :: postgresql alter column nullable 
Sql :: add constraint fk 
Sql :: upload database mysql command line 
Sql :: check database size in mysql 
Sql :: delete triger pl pg sql 
Sql :: Mysql Workbench takes very long time to execute the first query 
ADD CONTENT
Topic
Content
Source link
Name
7+3 =