Final answer:
To add a column to a table in SQL Server Management Studio, you can use either the table designer or a query with the ALTER TABLE statement, specifying the table name, column name, and data type.
Step-by-step explanation:
To add a column in SQL Server Management Studio (SSMS), you typically use the ALTER TABLE statement in a new query. Here's a step-by-step example of how to add a new column named 'NewColumn' with the data type INT to an existing table named 'MyTable': Open SQL Server Management Studio. Connect to the database where the table exists. Locate the table in the Object Explorer, right-click on it, and select 'Design' to use the table designer. Alternatively, you can use the New Query window.
If using Design view, simply add a new row in the designer and specify the column name, data type, and other properties, then save the changes. If using the New Query window, type the following SQL command: ALTER TABLE My Table ADD New Column INT and execute it. Remember to replace 'My Table' and 'New Column' with the actual names of your table and the new column respectively. Also, choose the appropriate data type for the new column.