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?
Similar Posts