Query the INFORMATION_SCHEMA for Table Information

A very useful command to query for information about a table from INFORMATION_SCHEMA.

Select * From INFORMATION_SCHEMA.COLUMNS Where TABLE_NAME='TableName'