tablespace clause

[ali0482]

What happens if a tablespace clause is left off of a primary key constraint clause?

[kbw]

This isn't an SQL forum.

[Philip Lee Bridson]

I agree with kbw - this is not the place for that question.

However, as I am a DBA by trade the answer is below...

If you create the primary key as part of the create table statement then the primary key will be created on whatever tablespace is used in the create table statement. If no tablespaces are specified in either the create table statement or the primary key constraint then they are both created on the default tablespace.

I hope this helps - but in future post in the right place. :)

Kind Regards,

Phil.