
Database Processing: Fundamentals, Design, and Implementation 13th Edition by David Kroenke, David Auer
Edition 13ISBN: 978-0133058352
Database Processing: Fundamentals, Design, and Implementation 13th Edition by David Kroenke, David Auer
Edition 13ISBN: 978-0133058352 Exercise 2
Write an SQL statement to create a table named PICTURE with columns Name, Description, DateTaken, and FileName. Assume that Name is char(20), Description is varchar(200), DateTaken is smalldate, and FileName is char(45). Also assume that Name and DateTaken are required. Use Name as the primary key. Set the default value of Description to '(None)'.
Explanation
CREATE TABLE PICTURE(
Name Cha...
Database Processing: Fundamentals, Design, and Implementation 13th Edition by David Kroenke, David Auer
Why don’t you like this exercise?
Other Minimum 8 character and maximum 255 character
Character 255

