Adding New Fields in a Table
Learn about adding new fields in the database.
Adding columns to a table
To comply with the newly implemented policy, our initial action is to add Quantity
and Price
to the SalesData
table.
Press + to interact
To accomplish this, the following SQL command will be used:
Press + to interact
ALTER TABLE table_nameADD column_name datatype;
Replace column_name
and datatype
with the respective name and data type for the column you're adding. ...