View table schema using SQL

Use this query to get the schema:

select *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME='tableName'

Stackoverflow