>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.
If it's not broken, fix it until it is.
My Blog