RE: [SQLQueriesNoCode] How to get Field name of a Table through query
A better way to do this is the use the information_schema views.
This is becoming the preferred way to get information about the database structure.
From: nilesh babar [mailto:nilesh_babar2003@...]
Sent: Thursday, March 24, 2005 7:23 AM
Subject: Re: [SQLQueriesNoCode] How to get Field name of a Table through query
use following query
select name from syscolumns where id in (select id from sysobjects where name='employee')
'employee' is the table name.
govisathish <govisathish@...> wrote:
I need to get the field names of a Table through Query, I'm using SQL
SERVER database . Can Any one help me in this regard
Send instant messages to your online friends http://uk.messenger.yahoo.com