Query Data - SQL script to see all available tables

Use this query to see all available tables for making custom SQL queries...

 

SELECT 
    *
FROM
    information_schema.tables;

 

 This is to show all available columns within tables:

SELECT * 
FROM information_schema.columns;

 


Login to post a comment