>>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.

BTW why you need to DROP table?
Isn't ALTER TABLE work for you?