.png)
Schema Class
SQL Server 2008
The Schema object represents an ownership context for a SQL Server database object.
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.None|AutomatedPolicyEvaluationMode.CheckOnChanges|AutomatedPolicyEvaluationMode.CheckOnSchedule)] [PhysicalFacetAttribute] [StateChangeEventAttribute("CREATE_SCHEMA", "SCHEMA")] [StateChangeEventAttribute("ALTER_SCHEMA", "SCHEMA")] public sealed class Schema : ScriptNameObjectBase, IObjectPermission, ICreatable, IDroppable, IExtendedProperties, IScriptable, IAlterable
To get Schema object properties, users can be a member of the public fixed server role.
To set Schema object properties, users must have ALTER permission on the schema.
To create a schema, users must have CREATE SCHEMA permission on the database.
To drop a schema, users must have CONTROL permission on the schema.
To grant, deny, or revoke permissions to users on the schema, users must have CONTROL permission on the schema.
To transfer objects into the schema, users must have CONTROL permissions on the object and ALTER permissions on the schema.
