What sql query can I perform to show me the field names?

I am needing to run a query and get results based the field being equal to a particular value. However, I am not familiar with this database structure and need to view the individual names of the record fields. Is there a technique or query I can run in SQL 2008 that will give me this info?
jso2765Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
santoshmotwaniConnect With a Mentor Commented:
just do

DESCRIBE ;

or
try this

SELECT column_name,column_type,is_nullable,column_key,col  umn_default,extra FROM information_schema.COLUMNS WHERE
table_schema='' AND table_name=''
0
 
santoshmotwaniCommented:
select column_name,* from information_schema.columns
 where table_name = 'YourTableName'
0
 
jso2765Author Commented:
Where would I find the table name?
0
 
SharathData EngineerCommented:
You should know your database name, table name and column which you want to query.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.