Changing Table Names
• Although SQL or DBMS specific commands exist, there is no good command to change a table name except in the most simple cases.
– The table needs to be re-created under the new name, tested, and the old table is dropped.
• Changing a table name has a surprising number of potential consequences.
– Therefore, using views defined as table aliases is
more appropriate.
– Only views that define the aliases would need to be changed when the source table name is changed.
– Adding and deleting relationships
– Adding and removing relationships for denormalization