Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 How to get the names of all columns in a table

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-01-31 : 00:12:17
Johan writes "I've designed a dynamic survey creator that makes it possible for the user to make their own web surveys. The thing is that a new table is created evrytime they make a new survey to hold the answers of the ones that fill in the forms. The problem is that I can't know in advance the name of the columns that are created in these tables.
How can I get the names of the existing columns in a table?"

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-01-31 : 00:17:09
Hi there

This should give you some clues...

http://www.sqlteam.com/item.asp?ItemID=2971



Damian
Go to Top of Page
   

- Advertisement -