expand icon
book Database Processing: Fundamentals, Design, and Implementation 13th Edition by David Kroenke, David Auer cover

Database Processing: Fundamentals, Design, and Implementation 13th Edition by David Kroenke, David Auer

Edition 13ISBN: 978-0133058352
book Database Processing: Fundamentals, Design, and Implementation 13th Edition by David Kroenke, David Auer cover

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
Verified
like image
like image

CREATE TABLE PICTURE(
Name Cha...

close menu
Database Processing: Fundamentals, Design, and Implementation 13th Edition by David Kroenke, David Auer
cross icon