Some Important SQL Queries

For geting ALL table_names From Database : SELECT table_name FROM information_schema.tables WHERE table_type='BASE TABLE'
Show all tables : show tables
Show list of base tables : SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE table_type='BASE TABLE'
Show list of all tables : SELECT * FROM INFORMATION_SCHEMA.TABLES
Count Base tables base tables : SELECT count(*) AS TotalTable FROM INFORMATION_SCHEMA.TABLES WHERE table_type='BASE TABLE'
coumls present in tables : SELECT TABLE_ROWS FROM INFORMATION_SCHEMA.TABLES WHERE table_type='BASE TABLE'
For Stucture Of Table : DESC table_name

Login
ADS CODE