 |  |  |  |  |  |  |  |
Assigning Foreign Keys
Please support our Database Design advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
•
•
Join Date: Mar 2004
Posts: 634
Reputation: 
Solved Threads: 7
Practically a Master Poster
Hey all, I have a table with a primary key in it. I use stored procedures to insert new records. What I want to know is how do I make it so a column (foreign key) in another table adds the same number as the primary key in the original table when a new record is inserted? Thanks.
Using T-SQL
Slade.
Using T-SQL
Slade.
Formerly known as Slade.
|
Similar Threads
- insert into multiple tables linked by foreign keys (PHP, MySQL) (PHP)
- SQL statement to count foreign keys (MySQL)
- Foreign keys from one table to a parent field (Database Design)
- Lots of Foreign keys...locking? (MySQL)
- Help with composite and Foreign Keys (Database Design)
- DB Design, trying to keep in sync without foreign-keys (Database Design)
- Varchar field as foreign reference (MySQL)
- mySQL foreign keys (MySQL)
Other Threads in the Database Design Forum
- Previous Thread: "Not" operator not functioning in t-sql
- Next Thread: How to display column descriptions?
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Database Design Posts
- Today's Posts
- Unanswered Threads
