Is it necessary to drop and re-create tables when adding or moving columns in SQL Server Management Studio?

edit

No, it is not necessary to drop and re-create tables when adding or moving columns in SQL Server Management Studio. You can use the ALTER TABLE statement to add or modify columns in an existing table. However, it is important to make sure that any changes you make do not break any existing code or stored procedures that may be relying on the old table structure.