> I have a field name in a db that I'd like to rename from fieldname1 to
> fieldname2 (leaving the data intact and fieldspecs the same) via a SQL
> statement.
MySQL is unusually obliging in this respect. IIRC in SQL Server you need to
use sp_rename() to rename a column.
I'm not at all sure this will work in Oracle either.
You can do it in a fairly DBMS-independent way by using a temporary column.
Nick
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
