quinta-feira, 13 de junho de 2013

Change Column Name - SQLServer/MySQL

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