At 05:47 PM 9/6/2013, Bruce A. Chitiea wrote:
Is there a way to code these key-column name changes (e.g. something like ALTER TABLE with an index override)?
Bruce, The simple answer, No. Preserving Referential Data Integrity is among the strengths of R:BASE! You must follow the rules and the process using the Graphical Data Designer, (RBDefine) where everything is validated before finalizing changes, etc. Having said that, depending on the number of tables, columns, and associated indexes, you can UNLOAD the database STRUCTURE only to a file, carefully edit the file using R:BASE Editor and then re-built the database SCHEMA again. During the build process every referential integrity is checked. Caution: Manually modifying the R:BASE database structure file requires the in-depth knowledge and understanding of R:BASE schema, syntax, and relationship. The new and enhanced Graphical Data Designer (RBDefine) in R:BASE eXtreme 9.5 (32/64) is designed and intended to avoid human error(s), and keeping everything in perspective and true-relational. Hope that helps! Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase -- 30+ years of continuous innovation! 15 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
