Create table driver (licence_no, Name, Address) and perform the following queries
1. Add new column age of data type integer.
2. Alter table by modifying driver_name to “Patil”
3. Alter table driver ,drop the column age.
4. Remove the driver table from the database.
Answers
Answer:
1. ALTER TABLE driver
ADD COLUMN AGE int;
2. ALTER TABLE driver
RENAME COLUMN driver to Patil;
3. ALTER TABLE driver
DROP COLUMN AGE;
4 DROP TABLE driver;
Explanation:
In the database, data is kept in tables. Within a database and schema, each table has a distinct name. There are one or more columns in each table. Additionally, each column has a corresponding data type that specifies the sort of data it can hold, such as strings, numbers, or temporal data.
Tables provide for quick and easy reading of issues displayed in rows and columns. Due to their straightforward design, adaptability, and convenience of use, they can be used frequently for benefit-risk messaging.
To learn more details about the database, Visit:
https://brainly.com/question/518894
To learn more example of database, Visit:
https://brainly.com/question/13485235
#SPJ3