Database.IsUpdateable Database.IsUpdateable Database.IsUpdateable Property

Definition

Gets a value that specifies whether the database can be updated.

public:
 property bool IsUpdateable { bool get(); };
[Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcProperty(Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.Standalone | Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.SqlAzureDatabase)]
public bool IsUpdateable { get; }
Public ReadOnly Property IsUpdateable As Boolean
Property Value

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  

Applies to