MS SQL Server Concepts and Programming Question:
Download Questions PDF

How To Create a New Table in a Given Schema?

Answer:

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".

Download MS SQL Server Interview Questions And Answers PDF

Previous QuestionNext Question
How To List All Schemas in a Database?How To Transfer an Existing Table from One Schema to Another Schema in MS SQL Server?