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;

BY LOVE SINGH on May 19 2020

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

PREVIOUS	NEXT

Code Example
Sql :: postgresql print sessions using the database
Sql :: postgres get month name from date
Sql :: mysql where one year ago
Sql :: mysql backup
Sql :: mysql last 6 months
Sql :: not today mysql
Sql :: oracle last character of string
Sql :: mysql import gz
Sql :: mariadb alter user host
Sql :: oracle list dblink
Sql :: InnoDB: page_cleaner: 1000ms intended loop took 7742ms. The settings might not be optimal
Sql :: how to copy a table from one database to another in mysql
Sql :: mysql increment value by 1 in update
Sql :: mysql loop insert
Sql :: import sql file laravel cmd
Sql :: sql exclude duplicates and find even id
Sql :: concat first name and last name in mysql
Sql :: Starting mysql shell lampp ubuntu
Sql :: hibernate dialect property xml for mysql 8
Sql :: how to check database size mysql
Sql :: sqlite foreign key
Sql :: execution plan oracle
Sql :: sql remove first character from string
Sql :: table infromation in sql server
Sql :: oracle activate job
Sql :: oracle plan hash value
Sql :: postgresql transaction discard all
Sql :: sql random decimal
Sql :: conda install pymysql "windows"
Sql :: drop table in mysql