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 SUSE

drop_database

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

NAME

       DROP DATABASE - remove a database

SYNOPSIS

       DROP DATABASE [ IF EXISTS ] name

DESCRIPTION

       DROP  DATABASE drops a database. It removes the catalog entries for the database and deletes the directory containing the data. It can only
       be executed by the database owner.  Also, it cannot be executed while you or anyone else are connected to the target database. (Connect	to
       postgres or any other database to issue this command.)

       DROP DATABASE cannot be undone. Use it with care!

PARAMETERS

       IF EXISTS
	      Do not throw an error if the database does not exist. A notice is issued in this case.

       name   The name of the database to remove.

NOTES

       DROP DATABASE cannot be executed inside a transaction block.

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

COMPATIBILITY

       There is no DROP DATABASE statement in the SQL standard.

SEE ALSO

       CREATE DATABASE [create_database(7)]

SQL - Language Statements					    2010-05-14							  DROP DATABASE(7)