When you create a new table, you can specify in which schema you want this table to be located by prefixing the table name with the schema name. In the tutorial example below, a new table "test" is created in schema "ggl":

USE GlobalGuideLineDatabase;

GO

CREATE TABLE ggl.test (id INT);

GO

Command(s) completed successfully.

SELECT t.name AS table_name, t.type_desc,

s.name AS schema_name

FROM sys.tables t, sys.schemas s

WHERE t.schema_id = s.schema_id

AND t.name = 'test';

GO

table_name type_desc schema_name

----------- ----------- ------------

test USER_TABLE ggl

The last query confirms that table "test" is inside schema "ggl".