Chapter 9 SQL Statements
383
ALTER DATABASE statement
Use this statement to upgrade a database created with previous versions of
the software.
ALTER DATABASE UPGRADE
… [ JAVA { ON | OFF } ]
… [ JCONNECT { ON | OFF } ]
Must have DBA authority, and must be the only connection to the database.
Not supported on Windows CE.
Automatic commit
"CREATE DATABASE statement" on page 427
"The Upgrade utility" on page 145
You can use the ALTER DATABASE statement as an alternative to the
Upgrade utility to upgrade a database.
Backup before upgrading
As with any software, it is recommended that you make a backup of your
database before upgrading.
ALTER DATABASE upgrades databases created with earlier versions of the
software. This applies to maintenance releases as well, so you can upgrade a
database created with, for example, version 6.0.2, to 6.0.3 standards using
the ALTER DATABASE statement in version 6.0.3 of the software.
In general, changes in databases between minor versions are limited to
additional database options and minor system table changes.
ALTER DATABASE makes the following changes:
♦ Upgrades the system tables to the current version.
♦ Adds any new database options.
♦ All system stored procedures are dropped and recreated.
♦ Running ALTER DATABASE twice, or running ALTER DATABASE
on an already upgraded database, does not make any changes.
You cannot use ALTER DATABASE to just add Java or jConnect features if
the database was created with the current version of the software. In order to
add these features to a database created with the current version of the
software, you must use Sybase Central or Interactive SQL.
Function
Syntax
Permissions
Side effects
See also
Description
To Next Page
Loading...