Hi.

Any way to ask database if a table exists? because it can be at the folder but not in the
database.

Thank you.

Francisco,

You can search the "Information.Tables" table. For example:
   SELECT * FROM Information.Tables
returns all tables in the database.

--
Fernando Dias
[Team Elevate]

Francisco

>Any way to ask database if a table exists? because it can be at the folder but not in the
>database.

You need to query one of the system information tables.

eg

select Name from information.tables where Name = 'yourname'

and check to see if it returns anything

Roy Lambert [Team Elevate]

Ok.

Thank you all