View table schema using SQL

less than 1 minute read

View table schema using SQL

Use this query to get the schema:

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

Stackoverflow

Leave a comment