$2\mathrm{.}14$ LAB $-$ Alter Movie table

The Movie table has the following columns:

ID $-$ positive integer

Title $-$ variable$-$length string

Genre $-$ variable$-$length string

RatingCode $-$ variable$-$length string

Year$-$integer

Write ALTER statements to make the following modifications to the Movie table:

Add a Producer column with VARCHAR data type $($max $50$ chars$).$

Remove the Genre column.

Change the Year column's name to ReleaseYear, and change the data type to SMALLINT.

Note: Your SQL code does not display any results in Develop mode. Use Submit mode to test your code.

$\frac{?}{{?}_{A}B}2\mathrm{.}14\mathrm{.}1$: LAB $-$ Alter Movie table

Main.sql

Load default template.