How To Create a New Table in a Given Schema?
Submitted by: AdministratorWhen 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".
Submitted by: Administrator
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".
Submitted by: Administrator
Read Online MS SQL Server Job Interview Questions And Answers
Top MS SQL Server Questions
☺ | How to download Microsoft SQL Server 2005 Express Edition? |
☺ | How To Create a Testing Table with Test Data in MS SQL Server? |
☺ | What Happens If Strings Are Casted into Wrong Code Pages in MS SQL Server? |
☺ | How To Declare and Use Cursor Variables? |
☺ | PHP MSSQL - How To Display a Past Time in Days, Hours and Minutes? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |