2.7 LAB - Alter Movie table The Movie table has the following columns:ID - integer, primary keyTitle - variable-length stringGenre - variable-length stringRatingCode - variable-length stringYear - integerWrite 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.

Introduction: SQL(Structured Query Language) is a programming language that is used to manage…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

2.7 LAB - Alter Movie table

The Movie table has the following columns:

ID - integer, primary key
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.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions