How to list all columns from a table in MSSQL

Jun 14, 2014 all, column, columns, every, get, list, object_id, select, Table, tables

To list all columns from a table in MSSQL you can use the following snippet.

Sample MSSQL

SELECT * FROM sys.columns WHERE object_id = OBJECT_ID('TABLENAME') ORDER BY name ASC

If you are using Oracle, take a look at this snippet -> How to get all column names of a Table in Oracle

May 22, 2015 Administrator

Apr 21, 2015 Administrator

Apr 15, 2015 Administrator

Realliferulor says:

June 14, 2014 at 3:35 pm

RT @CodeSnippetsNET: How to list all columns from a table in #MSSQL http://t.co/c1LYRSkEUP #sql #programming

Log in to Reply