Question

Write SQL command to add a column of a string type of size 20 in the table course

Answer 1

Answer:

SYNTAX :

Alter table < table name>

add < column name> < data type & width size> ;

•As there is no mention of column name in Question. Let column name -" Name"

• String data type - 2 types - Char & Varchar

Command will be :

Alter table course

add name varchar (20) ;

Hope it helps !!!!