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.
To accomplish this, the following SQL command will be used:
ALTER TABLE table_nameADD column_name datatype;
Replace column_name
and datatype
with the respective name and data type for the column you're ...