Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PRIMARY AND FOREIGN KEY CREATION

Status
Not open for further replies.
ofsouto

ofsouto

Programmer
Joined
Apr 29, 2000
Messages
185
Location
BR
when I create a table on SQL-Server I can use "NOCHECK" option to add primary and foreign key.
Is there any similar option on Oracle?
 
Sort by date Sort by votes
If you mean to create constraint without making it active, try "DISABLE".
 
Upvote 0 Downvote
Look in the documentation for DISABLE constraints and for NOVERIFY.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

J
  • Locked
  • Question Question
Oracle iCare Gift & Loyalty Portlet - Setup and configurations.
Replies
0
Views
300
jandresHDS
J
EM1107
  • Locked
  • Question Question
How to convert CLOB data into number and compare it to other table.
Replies
4
Views
1K
carp
carp
kernal
  • Locked
  • Question Question
Extract string before the first "-" it finds and the space prior to the "-"
Replies
5
Views
638
carp
carp
cabbey77
  • Locked
  • Question Question
Concat and/or Pivot?
Replies
3
Views
480
cabbey77
cabbey77
EM1107
  • Locked
  • Question Question
Insert date and time using UTC time in a DATE column
Replies
14
Views
2K
EM1107
EM1107

Part and Inventory Search

Sponsor

Back
Top