There is no query to get the description of the table like in MySQL. Use sp_columns stored procedure to describe the table in SQL Server. exec sp_columns tableName; And also we can use sp_help to describe the table. sp_help is returned depend on whether name is specified, when it is specified, and what database object it is. exec sp_help tableName;