Database.Refresh Database.Refresh Database.Refresh Method

Definition

Updates the Database object.

public:
 override void Refresh();
public override void Refresh ();
Public Overrides Sub Refresh ()

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")  

'Rename the database  
db.Rename("AdventureWorks2012")  

'Refresh the properties on the database.  
db.Refresh()  
db.Rename("AdventureWorks2012")  

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")  
$db = New-Object Microsoft.SqlServer.Management.Smo.Database  
$db = $srv.Databases.Item("AdventureWorks2012")  

$db.Rename("AdventureWorks2012")  

$db.Refresh()  
$db.Rename("AdventureWorks2012")  

Remarks

The Refresh method updates the Database object properties from the instance of SQL Server. For information about refreshing data programmatically, see SQL Server Native Client Programming.

Applies to