Learn Intermediate SQL/

...

/

Adding New Fields in a Table

Adding New Fields in a Table

Learn about adding new fields in the database.

We'll cover the following...

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_name
ADD column_name datatype;

Replace column_name and datatype with the respective name and data type for the column you're ...