SQL-Kindly clarify the ambiguity

[vensriram]

In SQL at first I created a table as follows

create table employee
(
emp_code int,
sex char(1) default 'f',
constraint emp_primary primary key(emp_code)
)
 

Table was created without any errors

Then next when i tried to create an other table as follows

create table employee2
(
emp_code int,
employee_address varchar(20),
constraint fk_empcode foreign key(emp_code))

I got the following error

Msg 102, Level 15, State 1, Line 5
Incorrect syntax near 'emp_code'.

Hence kindly clarify the reason for the error and also suggest a suitable way to rectify the same

[Oralloy]

Try:

CREATE TABLE employee2 
( 
  emp_code INT, 
  employee_address VARCHAR(20),
  CONSTRAINT fk_empcode FOREIGN_KEY(emp_code) REFERENCES employee(emp_code)
)

You left out the REFERENCES bit

[vensriram]

Oh! yes...Thank u...