Hi,

dbo.is default owner/schema for MSSQL and each database.
The answer for your question is: Yes, because you can have in database two tables: dbo.anytable and my.anytable with different structure. "my" is next schema.

MartinaJ

>Hi,
>
>I need to check (from a VFP 9 application) if a table in the SQL Server DB exists. I found a pretty simple code in one of the online threads. The code is as follows:
>
>

>IF not (EXISTS (SELECT * 
>                 FROM INFORMATION_SCHEMA.TABLES 
>                 WHERE TABLE_SCHEMA = 'DBO' 
>                 AND  TABLE_NAME = 'MyTable'))
>BEGIN
>    print 'does not exists'
>END
>

>
>My question is about the Table_Schema. In general I still don't understand what is the SQL Schema. If I put the 'DBO' in the Table_Schema above, the code works; the table - if exists - is found. But could there be a case - in the customer SQL Server database - that I need to enter something different than 'DBO'? Or, to be safe, should I drop the TABLE_SCHEMA from the WHERE completely?
>
>TIA