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'

Comments