On 04-Feb-2011 21:00, Steven Backus wrote:
Quote:
I have a large table and need to add a value to one of the rules.
Is there a way to do this without dropping and re-creating the
table? I'm using ASE 15.5.
Thanks,
Steve |
Unbind the rule (from all columns it is bound to), then drop and
recreate the rule as needed, and re-bind it.
HTH,
Rob V.
-----------------------------------------------------------------
Rob Verschoor
Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase
Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks& Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"
rob (AT) NO (DOT) SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------