Adding New Fields in a Table
Understand how to modify existing database tables by adding new columns with the SQL ALTER TABLE statement. This lesson shows how to add single or multiple fields such as Quantity and Price, set data types, and apply NULL or NOT NULL constraints for clearer database design.
We'll cover the following...
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.
...