Database.IsUpdateable Property
Gets a value that specifies whether the database can be updated.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Bildirim
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public ReadOnly Property IsUpdateable As Boolean
Get
'Kullanım
Dim instance As Database
Dim value As Boolean
value = instance.IsUpdateable
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public bool IsUpdateable { get; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase)]
public:
virtual property bool IsUpdateable {
bool get () sealed;
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
abstract IsUpdateable : bool
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
override IsUpdateable : bool
final function get IsUpdateable () : boolean
Property Value
Type: System.Boolean
A Boolean value that specifies whether the database can be updated.
If True (default), the database can be updated. Otherwise, False.
Implements
Examples
VB
'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Reference the AdventureWorks2012 database.
Dim db As Database
db = srv.Databases("AdventureWorks2012")
'Display information about the database.
Console.WriteLine("Is Database snapshot : " + _
db.IsDatabaseSnapshot.ToString)
Console.WriteLine("Is Database snapshot base : " + _
db.IsDatabaseSnapshotBase.ToString)
Console.WriteLine("User is Aministrator : " + _
db.IsDbAccessAdmin.ToString)
Console.WriteLine("User is backup operator : " + _
db.IsDbBackupOperator.ToString)
Console.WriteLine("User is data reader : " + _
db.IsDbDatareader.ToString)
Console.WriteLine("User is data writer : " + _
db.IsDbDatawriter.ToString)
Console.WriteLine("User is DDL administrator : " + _
db.IsDbDdlAdmin.ToString)
Console.WriteLine("User denied data reader : " + _
db.IsDbDenyDatareader.ToString)
Console.WriteLine("User denied data writer : " + _
db.IsDbDenyDatawriter.ToString)
Console.WriteLine("User is database owner : " + _
db.IsDbOwner.ToString)
Console.WriteLine("User security administrator : " + _
db.IsDbSecurityAdmin.ToString)
Console.WriteLine("Full text is enabled : " + _
db.IsFullTextEnabled.ToString)
Console.WriteLine("Database is a mail host : " + _
db.IsMailHost.ToString)
Console.WriteLine("Mirroring is enabled : " + _
db.IsMirroringEnabled.ToString)
Console.WriteLine("Database is a system object : " + _
db.IsSystemObject.ToString)
Console.WriteLine("Database is updateable : " + _
db.IsUpdateable.ToString)
PowerShell
$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2012")
Write-Host "Is database snapshot :" $db.IsDatabaseShapshot
Write-Host "Is database snapshot base :" $db.IsDatabaseShapshotBase
Write-Host "User is Administrator :" $db.IsDbAccessAdmin
Write-Host "User is backup operator :" $db.IsDbBackupOperator
Write-Host "User is data rader :" $db.IsDbDataReader
Write-Host "User is data writer :" $db.IsDbDataWriter
Write-Host "User is DDL administrator :" $db.IsDbDdlAdmin
Write-Host "User denied data reader :" $db.IsDbDenyDatareader
Write-Host "User denied data writer :" $db.IsDbDenyDatawriter
Write-Host "User dis database owner :" $db.IsDbOwner
Write-Host "User security administrator :" $db.IsDbSecurityAdmin
Write-Host "Full text is enabled :" $db.FullTextEnabled
Write-Host "Database is a mail host :" $db.IsMailHost
Write-Host "Mirroring is enabled :" $db.IsMirroringEnabled
Write-Host "Database is a system object :" $db.IsSystemObject
Write-Host "Database is updateable :" $db.IsUpdateable
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace