Share via

Schema.Owner Property

  • Article

Gets the owner of the schema.

This API is not CLS-compliant. 

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
<SfcReferenceAttribute(GetType(ApplicationRole), "Server[@Name = '{0}']/Database[@Name = '{1}']/ApplicationRole[@Name = '{2}']",  _
    )> _
<CLSCompliantAttribute(False)> _
<SfcReferenceAttribute(GetType(User), "Server[@Name = '{0}']/Database[@Name = '{1}']/User[@Name = '{2}']",  _
    )> _
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Design)> _
<SfcReferenceAttribute(GetType(DatabaseRole), "Server[@Name = '{0}']/Database[@Name = '{1}']/Role[@Name = '{2}']",  _
    )> _
Public Property Owner As String 
    Get 
    Set
'Usage
Dim instance As Schema 
Dim value As String 

value = instance.Owner

instance.Owner = value

[SfcReferenceAttribute(typeof(ApplicationRole), "Server[@Name = '{0}']/Database[@Name = '{1}']/ApplicationRole[@Name = '{2}']", 
    )]
[CLSCompliantAttribute(false)]
[SfcReferenceAttribute(typeof(User), "Server[@Name = '{0}']/Database[@Name = '{1}']/User[@Name = '{2}']", 
    )]
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)]
[SfcReferenceAttribute(typeof(DatabaseRole), "Server[@Name = '{0}']/Database[@Name = '{1}']/Role[@Name = '{2}']", 
    )]
public string Owner { get; set; }

[SfcReferenceAttribute(typeof(ApplicationRole), L"Server[@Name = '{0}']/Database[@Name = '{1}']/ApplicationRole[@Name = '{2}']", 
    )]
[CLSCompliantAttribute(false)]
[SfcReferenceAttribute(typeof(User), L"Server[@Name = '{0}']/Database[@Name = '{1}']/User[@Name = '{2}']", 
    )]
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase|SfcPropertyFlags::Design)]
[SfcReferenceAttribute(typeof(DatabaseRole), L"Server[@Name = '{0}']/Database[@Name = '{1}']/Role[@Name = '{2}']", 
    )]
public:
property String^ Owner {
    String^ get ();
    void set (String^ value);
}

[<SfcReferenceAttribute(typeof(ApplicationRole), "Server[@Name = '{0}']/Database[@Name = '{1}']/ApplicationRole[@Name = '{2}']", 
    )>]
[<CLSCompliantAttribute(false)>]
[<SfcReferenceAttribute(typeof(User), "Server[@Name = '{0}']/Database[@Name = '{1}']/User[@Name = '{2}']", 
    )>]
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)>]
[<SfcReferenceAttribute(typeof(DatabaseRole), "Server[@Name = '{0}']/Database[@Name = '{1}']/Role[@Name = '{2}']", 
    )>]
member Owner : string with get, set

function get Owner () : String 
function set Owner (value : String)

Property Value

Type: System.String
A String value that specifies the owner of the schema.

Examples

Creating, Altering, and Removing Schemas

See Also

Reference

Schema Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Understanding the Database Schemas

CREATE SCHEMA (Transact-SQL)