Script Table As -> ALTER To - grayed out??? Why?
Probably because the only portion that could be sensibly scripted out without further knowing what you're doing would be
ALTER TABLE <Table name>
The rest of the command completely differs depending whether you want to add columns, alter a column, drop a column, add a constrain, drop a constraint, enable or disable a trigger, enable or disable change tracking, switch a partition, rebuild the table or set a table option.
I Googled a bit and it said if I use design it will copy all the data to a temp location, drop, then recreate the table.
So I assume it will preserve all PKIDs, but what if I had a 16 TB table, that would be a MASSIVE disk I/O operation...
Which is why most people will write the alter table statement themselves and leave the designer where it should be - closed.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass