Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
is it possible to rename a table in informix?
- Thread starter WiccaChic
- Start date
- Thread starter
- #3
vpshriyan are you an IBM'er? You are (thankfully) one the most knowledgable and prolific posters in this forum and I think you have saved me so much time that I should be writing you a check!
One more thing
- what happens to the indexes and views associated with the table? will the database take care of those?
One more thing
- what happens to the indexes and views associated with the table? will the database take care of those?Wic:
Nope, I'm not an IBMer, but do not mind becoming one! Thanks for the compliments and nice to know that you find my postings helpful and it saved your time. Thanks for your generousness.
When you rename a table, all existing indexes will be linked to the new table. If a view is based on a table that was renamed, and if the view resides in the same database as the table, the database engine updates the "sysviews" system catalog table with the new table name. Both these activities operate automatically.
Regards,
Shriyan
"Man who knows, knows, he knows nothing!"
Nope, I'm not an IBMer, but do not mind becoming one!
Thanks for the compliments and nice to know that you find my postings helpful and it saved your time. Thanks for your generousness.When you rename a table, all existing indexes will be linked to the new table. If a view is based on a table that was renamed, and if the view resides in the same database as the table, the database engine updates the "sysviews" system catalog table with the new table name. Both these activities operate automatically.
Regards,
Shriyan
"Man who knows, knows, he knows nothing!"
- Status
Similar threads
