I need to discover if a Field Exists in a specific database table on MS SQL Server 2000. I was using:
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = 'Field1'
this apparently is NOT the correct approach is it will default to the Master database not the database I'm connected to.
What is the correct way to determine if a field exists in a table for my database?