I need to add a primary key field to a populated table on MS SQL Server. The table is in production. I have read that certain activities/changes to a table cause it to be dropped and recreated. Knowing so little about this, it makes me wonder if that means the data will be deleted in the process. Although that would seem crazy to me, because I can easily add a new field to a MS Access table and not have the data wiped out.
So, here are the direct questions.
1. Does adding a new field to a table cause the table to drop and recreate?
2. Does dropping and recreating a table cause its data to be wiped out?