Explain what is a Schema in SQL Server 2005? Explain how to create a new Schema in a Database?
Submitted by: AdministratorA schema is used to create database objects. It can be created using CREATE SCHEMA statement. The objects created can be moved between schemas. Multiple database users can share a single default schema.
CREATE SCHEMA sample;
Table creation
Create table sample.sampleinfo
{
id int primary key,
name varchar(20)
}
Submitted by:
CREATE SCHEMA sample;
Table creation
Create table sample.sampleinfo
{
id int primary key,
name varchar(20)
}
Submitted by:
Read Online SQL Server Database Administrator Job Interview Questions And Answers
Top SQL Server Database Administrator Questions
| ☺ | How to trace the traffic hitting a SQL Server? |
| ☺ | What is DBCC? |
| ☺ | What is lock escalation? |
| ☺ | Is SQL Server implemented as a service or an application? |
| ☺ | What are isolation levels? |
Top New MS SQL Server Categories
| ☺ | SQL Server Database Administrator Interview Questions. |
| ☺ | SQL Server Service Broker Interview Questions. |
| ☺ | SQL Server Locks Interview Questions. |
| ☺ | SQL Server Constraints Interview Questions. |
| ☺ | MS SQL Data Mining Interview Questions. |
