Question
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 ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get StartedRecommended Textbook for
Linear Algebra
Authors: Jim Hefferon
1st Edition
978-0982406212, 0982406215
Students also viewed these Databases questions
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
View Answer in SolutionInn App