Self Referential table
-
Hi, How can I create a foreign key column which is referencing the same tables another column. And if I have already created the table then how can I alter the table to enforce the same. Any link or any sort of help will be very much usefull.
Thanks & Regards, Md. Abdul Aleem NIIT technologies
-
Hi, How can I create a foreign key column which is referencing the same tables another column. And if I have already created the table then how can I alter the table to enforce the same. Any link or any sort of help will be very much usefull.
Thanks & Regards, Md. Abdul Aleem NIIT technologies
What have you tried?
-
What have you tried?
-
I got the answer just create in normal way how we create table in SQL Server.
Thanks & Regards, Md. Abdul Aleem NIIT technologies
Exactly. A very handy technique.
-
Exactly. A very handy technique.
Learn something new every day. :doh:
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.