Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

SQL - SERVER  RSS feed

 
sreedhar meda
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
HELLO,
my problem is i'm unable to create a child table with reference key to the composite key in the parent table in sql-server. how can i make
up a query to do the above.
give me an example queries.
with warm regards,
sreedhar m
 
E
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Check SQL Server Books Online for this database specific question and examples. Specifically research the create table statement. Here is how to set up the foreign key (which is what you call a reference). Add this at the end of your column list:
CONSTRAINT FK_fkey_name FOREIGN KEY (person_id, ord_id, chicken_id)
REFERENCES barnyard (person_id, ord_id, chicken_id)

The first column list (after the foreign key) is the list of columns in the new table corresponding to the primary key columns in the 'parent' table. The references is of course, the parent table.
It should look something like this:
...
feed_type int,
farmer_name varchar(50),
CONSTRAINT ...
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!