Security3:create Schema

Creates a schema in the current database

The new schema is owned by one of the following Database-level principals:database user, database role, or application ro Le. Objects created within a schema is owned by the owner of the schema, and has a NULL principal_id in sys.obj ECTS. Ownership of Schema-contained objects can be transferred to any Database-level principal, but the schema owner always Reta INS CONTROL permission on objects within the schema.

Syntax

CREATE SCHEMA  <schema_name_clause> ::={schema_name| AUTHORIZATION Owner_name}

AUTHORIZATION owner_name

Specifies the name of the Database-level principal that would own the schema. This principal may own other schemas, and could not be the use of the current schema as its default schema.

1,example

CREATELOGIN Testloginname withPassword='j345#$) THB', Default_database=Db_studyGoCREATE USERTestusername forLOGIN Testloginname withDefault_schema=Test;GoCREATE SCHEMATestAUTHORIZATIONTestusername;GoCreate Tabletest.dt_test (IDint, Codeint);Go

Security3:create Schema