-
Hi, all
I know the syntax to create constraint,index with the initial table creation script with tablespace storage info. I also know how to alter table add constraint primary key with tablespace storage info. I can also alter table add constraint foreign key without specifying the tablespace.But I could not get right for the alter table add constraint foreign key with tablespace storage info. I would appreciate if someone can help me with the correct syntax and give me a working example. Thanks.
The following is the foreign key I want to add. The snytax is correct, but I can not add tablespace storage into to it.
ALTER TABLE "HUBADMIN"."STEALTH_NATIVEMSG"
ADD CONSTRAINT "STEALTH_NATIVEMSG_FK" FOREIGN KEY( "DB20_ATOMICID", "DB20_HOPSTATUS")
REFERENCES "HUBADMIN"."STEALTH_HDRS"("DB20_ATOMICID","DB20_HOPSTATUS");
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|