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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-09-02 : 06:52:32
|
| rajeshraj writes "how to get the field names ( design name ) from the table using query ( not procedure )" |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-09-02 : 09:36:34
|
You can reference the Information_Schema.Columns view:select * from information_schema.columnswhere table_name = 'Your Table Name'Owais
Make it idiot proof and someone will make a better idiot |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-09-03 : 01:56:52
|
| select * from myTable where 1=0-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
|
|
|
sql server 7.0