Login or Register to Ask a Question and Join Our Community


Software Releases - RSS News

H2 Database Engine 1.1.105 (Default branch)

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Special Forums News, Links, Events and Announcements Software Releases - RSS News H2 Database Engine 1.1.105 (Default branch)
# 1  
Old 12-19-2008
H2 Database Engine 1.1.105 (Default branch)
ImageH2 is an SQL database engine written in Java thatimplements the JDBC API. Embedded, server, andclustering modes are available. A browser basedconsole application is included. The database hasstrong security features. Disk based and in-memory databases and tables are supported.License: Mozilla Public License (MPL)Changes:
The tool DeleteDbFiles sometimes deleted files of other databases. LIKE and IN(..) did not always work inside a sub-query. User defined aggregate functions did not always work. MySQL compatibility has been improved. Foreign key constraints with mixed case column names did not work. In JaQu, the maximum length of a column can now be set.Image

Image

More...
Login or Register to Ask a Question

Previous Thread | Next Thread
Login or Register to Ask a Question

LEARN ABOUT REDHAT

drop_database

DROP 
DATABASE(7)						   SQL Commands 						  DROP DATABASE(7)

NAME

       DROP DATABASE - remove a database

SYNOPSIS

       DROP DATABASE name

   INPUTS
       name   The name of an existing database to remove.

   OUTPUTS
       DROP DATABASE
	      This message is returned if the command is successful.

       DROP DATABASE: cannot be executed on the currently open database
	      You  cannot  be connected to the database you are about to remove.  Instead, connect to template1 or any other database and run this
	      command again.

       DROP DATABASE: may not be called in a transaction block
	      You must finish the transaction in progress before you can call this command.

DESCRIPTION

       DROP DATABASE removes the catalog entries for an existing database and deletes the directory containing the data.  It can only be  executed
       by the database owner (usually the user that created it).

       DROP DATABASE cannot be undone. Use it with care!

   NOTES
       This  command  cannot  be executed while connected to the target database. Thus, it might be more convenient to use the shell script dropdb
       [dropdb(1)], which is a wrapper around this command, instead.

       Refer to CREATE DATABASE [create_database(7)] for information on how to create a database.

COMPATIBILITY

   SQL92
       DROP DATABASE statement is a PostgreSQL language extension; there is no such command in SQL92.

SQL - Language Statements					    2002-11-22							  DROP DATABASE(7)