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
2 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
The software which is freely available for use but source code may not be available comes under —
- Open-Source
- Firmware Software
- Freeware Software
- Proprietary Software
Which of the following is a valid variable name?
- 1name
- na*me
- name
- name one
The superimposition of computer-generated perceptual information over the existing physical surrounding is called …………… .
Seema is collecting data for her science project from science blogs, e-newspapers and various websites this process is known as …………… .
- Data Capturing
- Data Retrieval
- Data Storage
- All of these