Creating and altering tables with Java-SQL columns  Selecting, inserting, updating, and deleting Java objects

Chapter 3: Using Java Classes in SQL

Altering partitioned tables

If a table containing Java columns is partitioned, you cannot alter the table without first dropping the partitions. To change the table schema:

  1. Remove the partitions.

  2. Use the alter table command.

  3. Repartition the table.





Copyright © 2005. Sybase Inc. All rights reserved. Selecting, inserting, updating, and deleting Java objects

View this book as PDF