>How can I rename a field in a table of SQL Server ?
>
>I'm trying this syntax:
>
>? SQLEXEC(lnHandle, [alter table cd_colegio rename column 'Nome' to 'Colegio'])
>
>but I have no success with this code.
>
? SQLEXEC(lnHandle, [execute sp_rename 'cd_colegio.Nome','Colegio','COLUMN'])
----------------------------------
António Tavares Lopes