Sql

USE YOUR_DATABASE_NAME
SELECT *
FROM INFORMATION_SCHEMA.TABLES

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 :: mysql delete all except
Sql :: count column of tables psql
Sql :: rename table column postgresql
Sql :: oracle nextval
Sql :: how to extract year from date in sql
Sql :: run sql file in terminal
Sql :: phpmyadmin reset root password
Sql :: mysql update add to existing value
Sql :: sql server rtrim everything after character
Sql :: sql only five first row
Sql :: download mysql 64 bit
Sql :: create or replace view postgress
Sql :: select where duplicate mysql
Sql :: postgres show databases
Sql :: where id is in list sql
Sql :: python pandas df to postgres json table
Sql :: xampp import sql file command line
Sql :: temp table vs variable table in sql server
Sql :: oracle apex message quit website
Sql :: postgres set null
Sql :: What is dialect for Postgres
Sql :: null sql
Sql :: mysql récupérer le code création de vue
Sql :: mariadb json_extract
Sql :: sql escape quote
Sql :: import sql in postgresql
Sql :: como saber si tengo mysql instalado
Sql :: raiserror nowait sql server
Sql :: mysql order by two columns priority
Sql :: mysql delete data in table