>Did you have any constraints of that table?
>If not then you could use this (after a really good test of course)
>

>SELECT * INTO dbo.Tmp_YourTable FROM YourTable
>GO
>DROP TABLE dbo.YourTable
>GO
>EXECUTE sp_rename N'dbo.Tmp_YourTable', N'YourTable', 'OBJECT'
>GO
>

Still not exactly clear. I guess I could have tried select *, extra new fields into temptable and then rename...

But I do have constraints.

Anyway, I have a new more complex question now (sort of interface question), so I'll ask in a new thread.