• You have to manually supply the name, instead of letting SQL Server pick one.

    You can look up the format of the alter table statement in SQL Server Books Online.