microsoft.... SQL ,,,,

[Anon]

Hey all,

quick question, quick answer?

I need have an microsoft sql server compatable query to either A, return the column names for a given table, or B, limit the results to 0, or 1, so that I can process the column names from the result.

[Anon]

A:
select column_name
from information_schema.columns
where table_name = 'OGRISH'

B:
What ?

[Anon]

thanks I got it.