Login or Register to Ask a Question and Join Our Community


Software Releases - RSS News

H2 Database Engine 1.1.104 (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.104 (Default branch)
# 1  
Old 11-29-2008
H2 Database Engine 1.1.104 (Default branch)
Image H2 is an SQL database engine written in Java that implements the JDBC API. Embedded, server, and clustering modes are available. A browser based console application is included. The database has strong security features. Disk based and in-memory databases and tables are supported. License: Mozilla Public License (MPL) Changes:
The emergency reserve file has been removed. The DATEDIFF function is now compatible with MS SQL Server. Improved plugins for ActiveObjects and Oracle Toplink Essential are included. The cache memory usage calculation is more conservative. Large databases on FAT file systems are now supported. The database now tries to detect if the Web application is stopped. A memory leak in the fulltext search is fixed. The JaQu object-relation mapping tool has been improved. 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)