How Do I Create A Table Manager ( Emp#, Manager) Where Manager Is A F

1.	How Do I Create A Table Manager ( Emp#, Manager) Where Manager Is A Foreign Key Which References To Emp# In The Same Table? Give The Exact Ddl.
Answer» First CREATE MANAGER table with EMP# as the primary KEY. Then ALTER it to DEFINE the FOREIGN key. First CREATE MANAGER table with EMP# as the primary key. Then ALTER it to define the foreign key.

How Do I Create A Table Manager ( Emp#, Manager) Where Manager Is A Foreign Key Which References To Emp# In The Same Table? Give The Exact Ddl.

Answer»

First CREATE MANAGER table with EMP# as the primary KEY. Then ALTER it to DEFINE the FOREIGN key.

First CREATE MANAGER table with EMP# as the primary key. Then ALTER it to define the foreign key.