17 February 2012

Running the query in this snippet will get MSSQL column information. it fetches and displays information about all columns in the specified table, including details such as column name, data type, length, and other relevant attributes.

Source code viewer
  1. SELECT * FROM INFORMATION_SCHEMA.Columns WHERE TABLE_NAME = 'your_table_name'
Programming Language: SQL