dbTalk Databases Forums  

Change Rule without Dropping Table?

comp.databases.sybase comp.databases.sybase


Discuss Change Rule without Dropping Table? in the comp.databases.sybase forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Steven Backus
 
Posts: n/a

Default Change Rule without Dropping Table? - 02-04-2011 , 02:00 PM






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
--
Steven J. Backus Computer Specialist
University of Utah E-Mail: steven.backus (AT) utah (DOT) edu
Genetic Epidemiology Alternate: backus (AT) math (DOT) utah.edu
391 Chipeta Way -- Suite D Office: 801.587.9308
Salt Lake City, UT 84108-1266 http://www.math.utah.edu/~backus

Reply With Quote
  #2  
Old   
Rob V
 
Posts: n/a

Default Re: Change Rule without Dropping Table? - 02-05-2011 , 05:49 AM






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
-----------------------------------------------------------------

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.