Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

what's wrong with this code, the error message im getting is: Msg 2716, Level 16, State 1, Line 1 Column, parameter, or variable #4: Cannot

 what's wrong with this code, the error message im getting is: Msg 2716, Level 16, State 1, Line 1 Column, parameter, or variable #4: Cannot specify a column width on data type int.

CREATE TABLE Car( Id VARCHAR(10) PRIMARY KEY, Model_id VARCHAR(10), Color VARCHAR(45), Year INT(4), Mileage DECIMAL(4,2), Horse_power INT(10), Price DECIMAL(12,2), DriveTrain_id VARCHAR(10), Color_id VARCHAR(10), FOREIGN KEY (Model_id) REFERENCES Model(Id) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (DriveTrain_id) REFERENCES Drivetrain(Id) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (Color_id) REFERENCES Color(Id) ON UPDATE CASCADE ON DELETE CASCADE

);

Step by Step Solution

There are 3 Steps involved in it

Step: 1

The issue in your code is with the data type definition for ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Linear Algebra

Authors: Jim Hefferon

1st Edition

978-0982406212, 0982406215

More Books

Students also viewed these Databases questions