Home Forums SQL Server 7,2000 Administration Changing Field Names in Tables RE: Changing Field Names in Tables

  • February 16, 2005 at 7:12 am

    #542522

    check out

    SP_Rename 'OldTableName', 'NewTableName', 'OBJECT'

    SP_Rename 'dbo.Table.ColName', 'NewName', 'COLUMN'