9. Creating Databases : Commands for Working with a Database
 
Share this page                  
Commands for Working with a Database
You can perform the following basic operations on a database:
Tasks
Command
Create a database
createdb
View or change properties of a database
infodb, accessdb, vwinfo, GETCONF, SETCONF
Make a copy or back up and restore a database
ckpdb, clonedb, movedb, rollforwarddb, unloaddb, CSVEXPORT
Change the characteristics of an existing database
alterdb, extenddb, unextenddb, relocatedb
Tidy tables and indexes for system catalogs and user tables
sysmod, COMBINE, REWRITE, CONDENSE_LOG
Change current vectorwise.log
VWLOG_ROTATE, VWLOG_RELOAD
Remove a database
destroydb
For details on these commands, see the Command Reference and the SQL Language Guide.
You can also perform many of these tasks using Actian Director.