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

by

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‘sGetSchemaTable 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.

More Related Contents:

  1. How do I generate a random number for each row in a T-SQL select?
  2. Auto increment primary key in SQL Server Management Studio 2012
  3. SQL Server Linked Server Example Query
  4. Combine multiple results in a subquery into a single comma-separated value
  5. Infinite loop CTE with OPTION (maxrecursion 0)
  6. SQL Server IN vs. EXISTS Performance
  7. How to drop a table if it exists?
  8. PIVOT in sql 2005
  9. How to run the same query on all the databases on an instance?
  10. Atomic UPSERT in SQL Server 2005
  11. How FOR XML PATH(”) works when concatenating rows
  12. What is the Oracle equivalent of SQL Server’s IsNull() function?
  13. SQL Server BCP export corrupted file?
  14. How to find all the dependencies of a table in sql server
  15. SQL Recursive CTE: Finding objects linked by property
  16. SQL Client for Mac OS X that works with MS SQL Server [closed]
  17. Is there a way to retrieve the view definition from a SQL Server using plain ADO?
  18. PRINT statement in T-SQL
  19. Programmatically retrieve SQL Server stored procedure source that is identical to the source returned by the SQL Server Management Studio gui?
  20. T-sql – determine if value is integer
  21. Execute stored procedure with an Output parameter?
  22. How do you kill all current connections to a SQL Server 2005 database?
  23. SQL Server Full Text Search Escape Characters?
  24. How to set the maxrecursion option for a CTE inside a Table-Valued-Function
  25. SQL-Server: The backup set holds a backup of a database other than the existing
  26. Change type of a column with numbers from varchar to int
  27. ADO.NET calling T-SQL Stored Procedure causes a SqlTimeoutException
  28. SQL Server – How to insert a record and make sure it is unique
  29. Does the `nodes()` method keep the document order?
  30. How to calculate difference in hours (decimal) between two dates in SQL Server?

Leave a Comment