> I have a site that I have no access to the DB from work (SQL Server).

> I am getting an error with one of my queries.  It looks as if the
> field is either not there or spelled wrong.  Can anyone tell me how
> I can tell what fields I have for a table?

Select column_name
>From information_schema.columns
Where table_name='myTable'


If you check the information_schema views, they allow you too check on
all sorts of information

HTH



[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to