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
answer should be B ithink
option B is also valid!
Answer should be "B"