IT Questions and Answers :)

Thursday, April 5, 2018

What does the ALTER TABLE clause do ?

What does the ALTER TABLE clause do ?

  • The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table column
  • The SQL ALTER TABLE clause is used to insert data into database table
  • The SQL ALTER TABLE deletes data from database table
  • The SQL ALTER TABLE clause is used to delete a database table 

 
What does the ALTER TABLE clause do ?

EXPLANATION

Answer is A. SQL ALTER TABLE:  Modifies a table definition by altering, adding, or dropping columns and constraints, reassigning and rebuilding partitions, or disabling or enabling constraints and triggers.


SOURCE

https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-table-transact-sql
Share:

Popular Posts

Blog Archive