renaming example in sql
Example 1: alter table name sql
-- Microsoft SQL style
EXEC sp_rename 'TableOldName', 'TableNewName';
Example 2: modify column name in sql
ALTER TABLE `Table Name` MODIFY COLUMN `Column Name` Datatype(Size);
-- Microsoft SQL style
EXEC sp_rename 'TableOldName', 'TableNewName';
ALTER TABLE `Table Name` MODIFY COLUMN `Column Name` Datatype(Size);