Microsoft SQL Server doesn’t seem to have a describe command, and usually, folks seem to want to build a stored procedure to get the describe-like behaviors.  However, this is not always practical based on your permissions. So, the simple SQL below will provide describe-like the information in a pinch.  You may want to dress it up a bit, but I usually just use it raw, as shown below, by adding the table name.

Describe T-SQL Equivalent

Select *   From INFORMATION_SCHEMA.COLUMNS Where TABLE_NAME = ‘<<TABLENAME>>’;

Related References

• Microsoft SQL Server – Useful links
• SQL Server – Basic SQL Server Object Naming Convention Guidance
• SQL Server JDBC ISJDBC.CONFIG Configuration