>> I realize that the official answer to "can I rename an index" is "no", >> and that directly writing to the system tables is generally a poor idea. >> But still: How much damage can I cause by UPDATE on RDB$INDEX_NAME in >> RDB$INDICES and RDB$INDEX_SEGMENTS? I have this itch I would like to >> scratch, where I created a primary key of a table with a bad name... >> >> The target Firebird versions are 2.1 and 2.5. >> >> Thanks, >> >> Pepak > > Never mind, I actually *can* drop a primary key and create it again. > That solves the problem nicely.
Right, as long as no FK constraint references the primary key fields in question. You then would first need to drop the FK constraint(s). -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/