|
 |
About Us | |
|
SSWUG Articles | |
 |
Articles | |
|
FAQ |
|
Administration | |
|
Backup/Restore | |
|
Connectivity | |
 |
Development | |
|
General | |
|
Installation | |
|
OLAP | |
|
Replication | |
|
Transfer/move | |
|
Trouble | |
|
SQL 6.5 |
|
Scripts | |
|
Tips | |
|
Test Exams | |
|
Advertise | |
|
Download | |
|
History | |
|
Search | |
|
Traffic | |
|
Related Links | |
|
||
|
|
||
 How can I remove foreign keys through SQL Server 7.0/2000 Enterprise Manager? Answer: To drop foreign keys, you can do the following: 1. Run SQL Server Enterprise Manager. 2. Expand a server group; then expand a server. 3. Expand Databases; then expand appropriate database. 4. Click Tables; then right-click the table and choose 'Design Table'. 5. Click the 'Table and Index Properties' button on the top menu. 6. On the 'Relationships' tab choose appropriate relationship and click 'Delete' button. You can also drop foreign keys from the diagrams in the Enterprise Manager (make diagram and drop foreign keys). |