ALTER DBSPACE statement
386
Using ALTER DBSPACE with RENAME on the main dbspace, SYSTEM,
has no effect.
♦
SQL/92 Vendor extension
♦
Sybase Not supported by Adaptive Server Enterprise.
♦ Increase the size of the SYSTEM dbspace by 200 pages.
ALTER DBSPACE system
ADD 200
♦ Rename the file for dbspace
system_2
to
dbspace2
.
ALTER DBSPACE system_2
RENAME ’e:\db\dbspace2.db’
Standards and
compatibility
Examples
To Next Page
Loading...