tables¶
list the tables in a database
SELECT TABLE_NAME
FROM sandbox.INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
list the columns in a table - mysql
DESCRIBE name_of_table;
mssql
select * from information_schema.columns where table_name = 'tableName'