sql

SQL Server query to get table structure and column information

You can get table columns information from INFORMATION_SCHEMA.COLUMNS.

select *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME='table_name'
Was this helpful?