Modify the datatype program in SQL

 

Question:

Modify the datatype

Write a query to change the type of field Ac_Available in the buses table to varchar(5)

CODE:–

alter table buses MODIFY Ac_Available varchar(5);

• Tweet
• Share
• Share
• Share
• Share

Related Post

• Delete Records Payments in SQLQuestion:Contains the run and evaluate script of Oracle DML. Can be used as exampleWrite a query to
• Insert Records into Guest table in SQLQuestion:Insert the following records into “Guest” table based on schema given belowGUESTIDNAMEADDR
• Create Payments table program in SQLQuestion:Create Payments tableRefer the below schema and create the table payments.Column NameDatat
• Create Users table program in SQL Create Users tableRefer to the below schema and create the table USERS.Refer to the below sch