| can a table exist without a primary key? [message #2511] |
Mon, 22 July 2002 12:46  |
Godwin
Messages: 37
Registered: January 2002
|
Member |
|
|
Hi there,
I want to find out if a table can be without a primary key.
Is it also possible to have a table without a primary key but such table can have 2 foriegn keys belonging to 2 differrnt tables.
Am designing a database and seems to implement any of the above.
Thanks for yr response.
|
|
|
|
| Re: can a table exist without a primary key? [message #2512 is a reply to message #2511] |
Mon, 22 July 2002 12:56  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
1. a table can be without a primary key??
--> yes. You can have.
2. Is it also possible to have a table without a primary key but such table can have 2 foriegn keys belonging to 2 differrnt tables??
--> you can still refer columns in other tables.
but those columns should have to be primary keys.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
