Using SQL to Modify Data Dictionaries

Advantage SQL Engine

The following system procedures can be used to modify data dictionary properties by any client that can execute SQL statements. The procedures are built into the Advantage Database Server and the Advantage Local Server and are executed on the server.

sp_AddIndexFileToDatabase

sp_AddTableToDatabase

sp_AddUserToGroup

sp_CreateArticle

sp_CreateGroup

sp_CreateIndex

sp_CreateLink

sp_CreatePublication

sp_CreateReferentialIntegrity

sp_CreateSubscription

sp_CreateUser

sp_DisableTriggers

sp_DropArticle

sp_DropGroup

sp_DropLink

sp_DropPublication

sp_DropReferentialIntegrity

sp_DropSubscription

sp_DropUser

sp_EnableTriggers

sp_ModifyArticleProperty

sp_ModifyDatabase

sp_ModifyFieldProperty

sp_ModifyGroupProperty

sp_ModifyIndexProperty

sp_ModifyLink

sp_ModifyProcedureProperty

sp_ModifyPublicationProperty

sp_ModifySubscriptionProperty

sp_ModifyTableProperty

sp_ModifyUserProperty

sp_ModifyViewProperty

sp_MoveDDObjectFile

sp_RemoveIndexFile

sp_RemoveUserFromGroup

sp_RenameDDObject