Database Administrator Guide > Database Administrator Guide > Creating Databases > Commands for Working with a Database
Was this helpful?
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, catalogdb, accessdb, vwinfo
Make a copy or back up and restore a database
ckpdb, clonedb, rollforwarddb, copydb, unloaddb, relocatedb
Change the characteristics of an existing database
alterdb, extenddb, unextenddb, relocatedb
Tidy tables and indexes for system catalogs and user tables
sysmod, usermod, MODIFY...TO COMBINE, CONDENSE_LOG
Change current vectorwise.log
VWLOG_ROTATE, VWLOG_RELOAD
Drop a database
destroydb
To accomplish these tasks in Actian Director, use the Database options.
Last modified date: 04/03/2024