Do you ever wish to be able to "describe" a table in MSSQL?

It is not available in MSSQL but it can be done with the help of function and store procedure.

In this article, I will show you how it can be done.

First create a XML variable like this:

SELECT @xmlFldList = (select * from ftvDescribe('tSomeTable') for xml raw)

Then call the spDescribeSchema to describe the table.

declare @SchemaInText varchar(max) exec dbo.[spDescribeSchema] @xmlFldList, @SchemaInText output

Please see the actual code of these calls above in this How-To