create table dbo.testX (xx000 int)
GO
INSERT INTO dbo.testX (xx000) values (1)
GO
CREATE SCHEMA [xxx]
GO
create table xxx.testX (xx000 datetime)
GO
INSERT INTO xxx.testX (xx000) values (getdate())
GO
select * from dbo.testX
select * from xxx.testX
go
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'testX'
go
MartinaJ
>Hi Martina,
>
>This is the first time I am beginning to understand the schema (a little). Thank you!
>Just a follow up question.
>How would you add a table to the DB - using SSMS - with a different schema? (e.g. schema "my")
>
>>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