MSSQL DATABASE INTERVIEW QUESTIONS

What is the purpose of the ALTER TABLE statement in MSSQL?

How do you add a new column to an existing table using ALTER TABLE in MSSQL?

How do you rename a column in an existing table using ALTER TABLE in MSSQL?

How do you modify the data type of an existing column using ALTER TABLE in MSSQL?

How do you drop a column from an existing table using ALTER TABLE in MSSQL?

How do you add a primary key constraint to an existing table using ALTER TABLE in MSSQL?

How do you add a foreign key constraint to an existing table using ALTER TABLE in MSSQL?

How do you enable or disable constraints using ALTER TABLE in MSSQL?

How do you add a computed column to an existing table using ALTER TABLE in MSSQL?

Explain a scenario where using the ALTER TABLE statement is crucial for a business application in MSSQL and describe how you would implement it.