Q
Problem solve Get help with specific problems with your technologies, process and projects.

Creating table without primary key

I would like to create a table without a primary key. Does Oracle (10g) use the rowid as the default primary key in this situation?

I would like to create a table without a primary key. Does Oracle (10g) use the rowid as the default primary key in this situation?
There is no such thing in Oracle as a "default" primary key. The primary key is a constraint that enforces two things, that the value in the primary key is guaranteed to be unique among each row, and that the value is NOT NULL. It is true that the primary key can be used to uniquely identify a row. And the same can be said of a ROWID. However, the ROWID does not enforce the uniqueness and not null constraints. It is good practice to add a PK constraint to each of your tables.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close