How can I show the table structure in SQL Server query?

sql-server

Solution

For SQL Server, if using a newer version, you can use

select *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME='tableName'

There are different ways to get the schema. Using ADO.NET, you can use the schema methods. Use the `DbConnection`'s `GetSchema` method or the `DataReader`'s`GetSchemaTable` method.

Provided that you have a reader for the for the query, you can do something like this:

using(DbCommand cmd = ...)
using(var reader = cmd.ExecuteReader())
{
    var schema = reader.GetSchemaTable();
    foreach(DataRow row in schema.Rows)
    {
        Debug.WriteLine(row["ColumnName"] + " - " + row["DataTypeName"])
    }
}

See this article for further details.

Problem

``` SELECT DateTime, Skill, Name, TimeZone, ID, User, Employee, Leader FROM t_Agent_Skill_Group_Half_Hour AS t ``` I need to view the table structure in a query.

Original source