|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
May 19th, 2004, 02:22 AM
|
|||
|
|||
|
Generte SQL Script and the Primary and foriegn key relationships...
Hi,
For the first time I tried to generate the SQL script (selected all the objects) for a database and in the SQL Query Analyser I used the generated script to create the tables in an empty database. All the tables were created except the primary keys and the foriegn key relationships. Is it designed to work in this way or am i missing anything. My requirement is with the SQL script I need to create the tables with all the relationships. How to achieve this. Thanks in advance.
__________________
Regards,  Brightlight
|
|
#2
May 20th, 2004, 01:17 AM
|
|||
|
|||
|
Hi,
I found the solution. While generating the SQL script, in the Options tab I need to select the Scripting Primary Keys and Foreign... option.
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Generte SQL Script and the Primary and foriegn key relationships... |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
