How To Create a New Schema in a Database?
Submitted by: AdministratorIf you want to create a new schema in an existing database, you can use the "CREATE SCHEMA" statement as shown in the tutorial example below:
USE GlobalGuideLineDatabase;
GO
CREATE SCHEMA ggl;
GO
Command(s) completed successfully.
A new schema called "ggl" has been created in "GlobalGuideLineDatabase" database. "ggl" is an empty schema at this moment since no objects has been moved into "ggl" yet.
Submitted by: Administrator
USE GlobalGuideLineDatabase;
GO
CREATE SCHEMA ggl;
GO
Command(s) completed successfully.
A new schema called "ggl" has been created in "GlobalGuideLineDatabase" database. "ggl" is an empty schema at this moment since no objects has been moved into "ggl" yet.
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? |
☺ | What Are Binary String Data Types in MS SQL Server? |
☺ | Can You Roll Back the DDL Statement in a Trigger? |
☺ | 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. |