You cannot alter a column name in SQL Server using 'Alter Table' the way you can in other DB models.
Other DBMSs aren't much better. Apart from Postgres (and maybe DB2), they use their own alter table syntax for renaming columns rather than implementing the SQL 92/99 syntax. God only knows why
Mark
-- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
