Export (0) Print Expand All Expand Minimize 18 out of 32 rated
this helpful - Rate this topic   Creates a schema in the current
database. The CREATE SCHEMA transaction can also create tables
and views within the new schema, and set GRANT, DENY, or REVOKE
permissions on those objects.  Topic link icon Transact-SQL
Syntax Conventions   <schema_name_clause> ::=     |
AUTHORIZATION owner_name     | schema_name AUTHORIZATION
owner_name  <schema_element> ::=          table_definition |
view_definition | grant_statement |          revoke_statement |
deny_statement   Is the name by which the schema is identified
within the database.   Specifies the name of the database-level
principal that will own the schema. This principal may own other
schemas, and may not use the current schema as its default
schema.   Specifies a CREATE TABLE statement that creates a
table within the schema. The principal executing this statement
must have CREATE TABLE permission on the current database.
Specifies a CREATE VIEW statement that