Vidyalelo
SQL · Q8

SQL

Programming · SQL · question 8

Q8

A command that lets you change one or more fields in a record is

A.
Insert
B.
Modify
Answer
C.
Look-up
D.
All of the above

Answer: Option B

Solution

Answer: Option B
Solution:

Sometimes we need to change the data type of a column. To do this, we use the ALTER TABLE Modify Column command.
Sytax:
ALTER TABLE table_name
MODIFY column_name "New Data Type"