Set the data type of name and description however you deem


Write a CREATE TABLE statement to create the table SLIDE_SHOW (Show ID, Name, Description, Purpose). Assume that Show ID is a surrogate key. Set the data type of Name and Description however you deem appropriate. Set the data type of Purpose to char (15), and limit it to the set of values (‘Home', ‘Office', ‘Family', ‘Recreation', ‘Sports', ‘Pets'). Execute your CREATE TABLE statement using Query Analyzer.

Solution Preview :

Prepared by a verified Expert
Basic Computer Science: Set the data type of name and description however you deem
Reference No:- TGS01604928

Now Priced at $20 (50% Discount)

Recommended (96%)

Rated (4.8/5)