I don't know about you, but I always forget the correct syntax to change column name.
SQLServer
sp_rename 'FileEstimation.email', 'Login', 'COLUMN';
The result
Caution: Changing any part of an object name could break scripts and stored procedures.
MySQL
alter table FileEstimation change email login varchar (100) ;
Now Oracle is in the house, but I think the syntax hasn't change for mysql.
Nenhum comentário:
Postar um comentário