Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can I rename a field in a table of SQL Server ?
Message
From
25/10/2002 17:00:53
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00715641
Message ID:
00715659
Views:
15
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform