public static void Refresh(DB db)
{
//reset
DBObjectManager.BeforeRefresh(db);
//self data
//get schemas
RefreshSchemas(db);
//get database triggers
RefreshTriggers(db);
//get database roles
RefreshRoles(db);
//get database users
RefreshUsers(db);
//properties
DBObjectManager.RefreshProperties(db);
//intact
DBObjectManager.AfterRefresh(db);
}
public static void Refresh(DBView v)
{
//reset
DBObjectManager.BeforeRefresh(v);
//self
//columns
DBObjectManager.RefreshColumns(v);
//properties
DBObjectManager.RefreshProperties(v);
//intact
DBObjectManager.AfterRefresh(v);
}
public static void Refresh(DBTable t)
{
//reset state and collections
DBObjectManager.BeforeRefresh(t);
//columns
DBObjectManager.RefreshColumns(t);
//primary key
RefreshPrimaryKey(t);
//triggers
RefreshTriggers(t);
//policies (select, update, delete)
RefreshPolicies(t);
//extensions (views/computed/secure) for extra columns
RefreshExtensions(t);
//table level properties
RefreshTableProperties(t);
//business
RefreshBusinessProcedures(t);
//foreign key relations
RefreshForeignKeys(t);
//check constraints
RefreshCheckConstraints(t);
//default constraints
RefreshDefaultConstraints(t);
//properties
DBObjectManager.RefreshProperties(t);
//state intact
DBObjectManager.AfterRefresh(t);
}
public static void Refresh(DBSchema s)
{
DBObjectManager.BeforeRefresh(s);
//get tables
RefreshTables(s);
//get views
RefreshViews(s);
//get procedures
RefreshProcedures(s);
//table valued functions
//scalar functions
//datatypes
//properties
DBObjectManager.RefreshProperties(s);
DBObjectManager.AfterRefresh(s);
}
