What is the impact when we change the table name. If there are dependencies or anything else related to the table which is going to change.
Please update me on this....
Regards, Srinivas Alwala
Use the given query to change the table name.
RENAME TABLE items TO item;
No, there will be no impact on table data. It will remain same. Only the table name will get changed.