get field names of a table in sql server

Question

0.00/5 (No votes)

See more:

Hello,
i want to fetch all fields of a table in sql server with cursor..
thanks for your help...

Posted 4-Feb-13 18:59pm

Comments

__TR__ 5-Feb-13 1:21am

You can use INFORMATION_SCHEMA.COLUMNS[^] to retrieve the column names of a table.

Mehdi Gholam 5-Feb-13 1:36am

You should write this as a solution.

__TR__ 5-Feb-13 1:56am

Done.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

__TR__ · Accepted Answer · 2013-02-04T19:53:00

You can use INFORMATION_SCHEMA.COLUMNS[^] to retrieve the column names of a table.
If you are not sure how to use cursor take a look at
SQL SERVER – Simple Example of Cursor[^]
DECLARE CURSOR (Transact-SQL)[^]

Posted 4-Feb-13 19:53pm

Comments

Mehdi Gholam 5-Feb-13 2:08am

5'ed

__TR__ 5-Feb-13 4:23am

Thanks.

Nirali R shah 7-Feb-13 7:22am

Thank you very much.... :)

__TR__ 7-Feb-13 7:24am

You are welcome!