• You can use sp_rename:

    EXEC sp_rename 'schema.table.name', 'newname', 'COLUMN'

    As for adding new columns, you can use ALTER TABLE:

    ALTER TABLE tablename ADD [column definition]

    -- Gianluca Sartori