Table Exist in MS-SQL

[colboy]

How can I check for the existence of a table within an MS-SQL database. At present I'm using a count wrapped in a try. This is fine if the table doesn't exist, or the table does exist and it's small. I'm sure I read of an Exist() function, does anyone know of it.

Colin

[r937]

do a query on INFORMATION_SCHEMA (see Books OnLine)