Examveda
Examveda

What SQL command can be used to add columns to a table?

A. ALTER TABLE TableName ADD ColumnName

B. ALTER TABLE TableName ADD COLUMN ColumnName

C. MODIFY TABLE TableName ADD ColumnName

D. MODIFY TABLE TableName ADD COLUMN ColumnName

Answer: Option A

Solution(By Examveda Team)

To add columns to a table in SQL, you can use the ALTER TABLE TableName ADD ColumnName command. Option A is the correct choice for adding new columns to an existing table. Options B, C, and D do not represent the standard SQL syntax for adding columns.

This Question Belongs to SQL >> Sql Miscellaneous

Join The Discussion

Comments ( 3 )

  1. Pankaj Jagdale
    Pankaj Jagdale :
    1 year ago

    answer should be B ithink

  2. Ahmed Raafat
    Ahmed Raafat :
    3 years ago

    option B is also valid!

  3. Subhankar Patra
    Subhankar Patra :
    8 years ago

    Answer should be "B"

Related Questions on Sql Miscellaneous