How do you return the column names of a table?

by

Not sure if there is an easier way in 2008 version.

USE [Database Name]
SELECT COLUMN_NAME,* 
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'YourTableName' AND TABLE_SCHEMA='YourSchemaName'

More Related Contents:

  1. SQL where clause odd behavior [closed]
  2. How do I obtain a Query Execution Plan in SQL Server?
  3. How do I escape a single quote in SQL Server?
  4. Simple way to transpose columns and rows in SQL?
  5. Only inserting a row if it’s not already there
  6. Unpivot with column name
  7. Selecting data from two different servers in SQL Server
  8. Maximum size for a SQL Server Query? IN clause? Is there a Better Approach [duplicate]
  9. How to split a single column values to multiple column values?
  10. Using the result of an expression (e.g. Function call) in a stored procedure parameter list?
  11. Formatting Numbers by padding with leading zeros in SQL Server
  12. When no ‘Order by’ is specified, what order does a query choose for your record set?
  13. How do I create a step in my SQL Server Agent Job which will run my SSIS package?
  14. For Nvarchar(Max) I am only getting 4000 characters in TSQL?
  15. How do I create a foreign key in SQL Server?
  16. How do I group on continuous ranges
  17. join comma delimited data column
  18. Need to list all triggers in SQL Server database with table name and table’s schema
  19. Count based on condition in SQL Server
  20. Is it possible to perform multiple updates with a single UPDATE SQL statement?
  21. Incorrect syntax near the keyword ‘with’…previous statement must be terminated with a semicolon
  22. Best equivalent for IsInteger in SQL Server
  23. Syntax of for-loop in SQL Server
  24. How to correctly insert newline in nvarchar [duplicate]
  25. How do you copy a record in a SQL table but swap out the unique id of the new row?
  26. Using IF ELSE statement based on Count to execute different Insert statements
  27. SQL – Call Stored Procedure for each record
  28. SQL – How do I get only the numbers after the decimal?
  29. How to retrieve records for last 30 minutes in MS SQL?
  30. Why do SQL Server Scalar-valued functions get slower?

Leave a Comment