Name
DESTROY-DATABASE — destroys a database
Function
Syntax
destroy-database connection-spec &key database-type => success
Arguments and Values
- connection-spec
A connection specification
- database-type
A database type specifier, i.e. a keyword.
This defaults to the value of
*default-database-type*
- success
A boolean flag. If T, the database was
successfully destroyed.
Description
This function destroy a database in the database system
specified by database-type.
Examples
(destroy-database '("localhost" "new" "dent" "dent") :database-type :postgresql)
=> T
(destroy-database '("localhost" "new" "dent" "dent") :database-type :postgresql)
=>
Error: While trying to access database localhost/test2/root
using database-type POSTGRESQL:
Error database-destory failed: dropdb: database removal failed: ERROR: database "test2" does not exist
has occurred.
[condition type: CLSQL-ACCESS-ERROR]
Side Effects
A database will be removed from the filesystem of the host.
Exceptional Situations
An exception will be thrown if the database system does not
allow databases to be removed, the database does not exist, or
if database removal fails.
Notes
This function may invoke the operating systems
functions. Thus, some database systems may require the
administration functions to be available in the current
PATH. At this time, the
:mysql backend requires
mysqladmin and the
:postgresql backend requires
dropdb.