>>user.
>>SSMS can build bad T-SQL scripts.
>
>Thank you, that explains.

However,
if you remove or add a field to a table with zillion records,
the operation is instantaneous because sql changes only the metadata of the table.

it is like to delete a 1000TB file on NTFS.