You can delete all the information in a partition without affecting information in other partitions. For example, to delete all rows from the q1 and q2 partitions of the fictionsales table, enter:
truncate table fictionsales partition q1
truncate table fictionsales partition q2
See the Reference Manual for complete syntax and usage information.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
