Rename column

From: SK (SK_at_discussions.microsoft.com)
Date: 12/21/04 

Date: Tue, 21 Dec 2004 08:03:04 -0800

How do I rename a column in SQL Server 7.0?

I used:
ALTER TABLE [MyTable] RENAME COLUMN oldColumnName TO newColumnName;

but it does not work, does this show that SQL Server 7.0 is not SQL-92
compliant?

Thanks in advance
SK

Relevant Pages

  • Re: Problem altering table and adding a default
    ... ALTER TABLE dbo.Test_tbl ADD Notnull_col1 charNOT NULL ... SQL Server does not allow that - you can only add nullable columns. ... After you add a new column in Enterprise Manager, uncheck Allow Nulls, bind the uder- ... Start Profiler and perform a new trace. ...
    (microsoft.public.sqlserver.server)
  • Re: Problem altering table and adding a default
    ... SQL Server does not allow that - you can only add nullable ... > After you add a new column in Enterprise Manager, uncheck Allow Nulls, ... the ALTER TABLE statement above will pass to the SQL Server ... > 4) Start Profiler and perform a new trace. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Express - Identity specification property - how to change
    ... UPDATE tbl ... You can use ALTER TABLE ALTER COLUMN to add an IDENTITY column, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: user defined Role - HELP
    ... I get an error "Privilege ALTER TABLE may not be granted or revoked. ... Grant ALTER TABLE on tblReportNums to 'UM Case Mgmt' ... Grant the role ALTER permission on the table. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.security)
  • Re: Cant DROP CONSTRAINT DF_ on a bit data type?
    ... ALTER TABLE MyTable DROP CONSTRAINT DF_MyTable_MyField ... Pro SQL Server 2000 Database Design - ... > Customers = MyTable ... >>> ALTER TABLE MyTable DROP CONSTRAINT DF_MyTable_MyField>>> ...
    (microsoft.public.sqlserver.programming)