I believe if you have FK on all the other columns related to the PK col, and you set the cascade option correctly that will do the trick. [cid:[email protected]]
James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Thursday, January 26, 2017 3:50 PM To: [email protected] Subject: [RBASE-L] - Changing a column definition Greeings: Is it possible to make a mass change to a column throughout a database with changing it in each individual table? I use the ALTER TABLE command to change a column in a table but I could've sworn I used a command to change a column definition in several tables at once. Maybe I'm just having a "moment". Thanks for any feedback. Mike Ramsour AK Steel Coshocton Works Quality Department Phone: 740-829-4340 Cell: 740-502-1659 Confidentiality Notice This message is intended exclusively for the individual or entity to which it is addressed and may contain privileged, proprietary, or otherwise private information. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. ________________________________ -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
