Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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
Examples
Managing Users, Roles, and Logins
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace