1.

What Is A Schema In Sql Server 2005? Explain How To Create A New Schema In A Database?

Answer»

A 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) }

A 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


Discussion

No Comment Found

Related InterviewSolutions