JOIN NOW

Informatics Practices

Anu wants to change the width of a column Author in a Table Library from Varchar(20) to Varchar(30). Which command should she use?

SQL Queries

3 Likes

Answer

Anu should use MODIFY clause with ALTER TABLE command to modify the data type size for the Author column from 20 to 30 characters. The command is as follows:

ALTER TABLE Library
MODIFY Author VARCHAR(30);

Answered By

2 Likes

Related Questions