Question:
Alter table payments
Write a query to rename a column from bd_id to booking_id in the table payments
Code:
alter1.sql
alter table payments RENAME COLUMN bd_id to booking_id;
Alter table payments in SQL
Write a query to rename a column from bd_id to booking_id in the table payments
alter table payments RENAME COLUMN bd_id to booking_id;