User.DefaultSchema Property

Gets the default schema for the database user.

This API is not CLS-compliant. 

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

Syntax

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

value = instance.DefaultSchema

instance.DefaultSchema = value

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

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

[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)>]
[<SfcReferenceAttribute(typeof(Schema), "Server[@Name = '{0}']/Database[@Name = '{1}']/Schema[@Name = '{2}']", 
    )>]
[<CLSCompliantAttribute(false)>]
abstract DefaultSchema : string with get, set
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)>]
[<SfcReferenceAttribute(typeof(Schema), "Server[@Name = '{0}']/Database[@Name = '{1}']/Schema[@Name = '{2}']", 
    )>]
[<CLSCompliantAttribute(false)>]
override DefaultSchema : string with get, set

final function get DefaultSchema () : String 
final function set DefaultSchema (value : String)

Property Value

Type: System.String
A String value that specifies the default schema for the database user.

Implements

IUserOptions.DefaultSchema

Examples

Managing Users, Roles, and Logins

See Also

Reference

User Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Principals (Database Engine)

CREATE USER (Transact-SQL)