Deletes a star schema from a given database.
To delete a star schema, the connected user must be assigned to the Application Administrator role. To check whether the user is assigned to this role, use the HsvSecurityAccess method IsApplicationAdministrator.
<HsvStarSchemaACM>.DeleteStarSchema bstrDSN, bstrTablePrefixString (ByVal). The Extended Analytics Data Source Name for the database that contains the star schema to be deleted. To get the Extended Analytics Data Source Names that have been registered on an application server, use EnumRegisteredDSNs. | |
String (ByVal). The Relational Table prefix, which is the prefix that identifies the star schema’s tables. All tables with names that begin with this prefix are deleted. |
The following example deletes a star schema named Widgets from a data source named ExtendedAnalytics.