Sql

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'

SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG='YOUR_Database_name'

select tablespace_name, table_name from all_tables;

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'

PREVIOUS	NEXT

Code Example
Sql :: tsql copy table
Sql :: get all schemas postgres
Sql :: check current sequence value postgres
Sql :: to date oracle with time
Sql :: sql query to get column names and data types in sql server
Sql :: liquibase alter column type / length
Sql :: pdo mysql insert
Sql :: find mysql version linux
Sql :: mysql get longest string in column
Sql :: sql server last executed query
Sql :: alter foreign key
Sql :: how to set an already made tables auto increment in mysql
Sql :: open postgress in terminal mac
Sql :: mysql where one year ago
Sql :: no data found oracle
Sql :: alter default column value oracle
Sql :: postgresql concatenate multiple rows in group by
Sql :: grant lock tables privilege mysql
Sql :: Check Table Exists
Sql :: sqlite insert row
Sql :: get columns number sql
Sql :: mysql get last id
Sql :: how to delete view in sql
Sql :: mysql set root password
Sql :: sql find column name like
Sql :: liquibase update row
Sql :: rename table snowflake
Sql :: laravel to sql
Sql :: mysql show charset
Sql :: start mysql linux terminal