i keep getting this message Msg 1778, Level 16, State 0, Line 23 Column 'salesman.salesman_id' is not the same data type as referencing column 'Customer.salesman_id' in foreign key 'FK_salesman_id'.
create
go
use GA2
go
create table salesman(
salesman_id int primary key,
name varchar(30),
city varchar(20),
commission varchar(30)
);
insert into salesman (salesman_id, name, city, commission) values (5001, 'James Hoog', 'New York', 0.15);
insert into salesman (salesman_id, name, city, commission) values (5002, 'Nail Knite', 'Paris', 0.13);
insert into salesman (salesman_id, name, city, commission) values (5005, 'Pit Alex', 'London', 0.11);
insert into salesman (salesman_id, name, city, commission) values (5006, 'Mc Lyon', 'Paris', 0.14);
insert into salesman (salesman_id, name, city, commission) values (5007, 'Paul Adam', 'Rome', 0.13);
insert into salesman (salesman_id, name, city, commission) values (5003, 'Lauson Hen', 'San Jose', 0.12);
Create table Customer (
customer_id int primary key,
cust_name varchar(30),
city varchar(10),
grade varchar(30),
salesman_id varchar(30),
CONSTRAINT FK_salesman_id FOREIGN KEY (salesman_id) REFERENCES salesman(salesman_id)
);
i keep getting this message
Msg 1778, Level 16, State 0, Line 23
Column 'salesman.salesman_id' is not the same data type as referencing column 'Customer.salesman_id' in foreign key 'FK_salesman_id'.
Msg 1750, Level 16, State 1, Line 23
Could not create constraint or index. See previous errors.
can you show me how to fix it, its SQL Server
Step by step
Solved in 2 steps
