If you want to move an existing table from one schema to another schema, you can use the "ALTER SCHEMA ... TRANSFER ..." statement as shown in the tutorial exercise below:

-- Login with "sa"

USE GlobalGuideLineDatabase;

GO

-- Confirming that "ggl_links" is in "dbo"

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 = 'ggl_links';

GO

table_name type_desc schema_name

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

ggl_links USER_TABLE dbo

-- Moving a table to a new schema

ALTER SCHEMA ggl TRANSFER ggl_links;

GO

-- Confirming that "ggl_links" is moved to "ggl"

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 = 'ggl_links';

GO

table_name type_desc schema_name

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

ggl_links USER_TABLE ggl

The last query confirms that table "ggl_links" is now in schema "ggl".