Function DESTROY-DATABASE — destroys a database
Function
destroy-database connection-spec &key database-type => success
A connection specification
A database type specifier, i.e. a keyword. This defaults to the value of *default-database-type*
A boolean flag. If T, the database was successfully destroyed.
This function destroys a database in the database system specified by database-type.
(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]
A database will be removed from the filesystem of the host.
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.
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.
destroy-database is a CLSQL extension.