SQL

get schema of table sql

SELECT `table_schema` 
FROM `information_schema`.`tables` 
WHERE `table_name` = 'whatever';

sql server get schema of table

-- This first query will return all of the tables in the database you are querying.
SELECT
  	TABLE_NAME
FROM
  	INFORMATION_SCHEMA.TABLES
ORDER BY TABLE_NAME


-- The second query will return a list of all the columns and tables in the database you are querying.
SELECT
  	TABLE_NAME,
	COLUMN_NAME
FROM
  	INFORMATION_SCHEMA.COLUMNS
ORDER BY TABLE_NAME