Forums Register Login

Create primary and foreign key with SQL

+Pie Number of slices to send: Send
Hi,
I'm new to SQL. I need to create a table that
has a primary key to be used by a CMP entity
bean. I used following to create the table:
create table my_table(id not null number,
val_1 number, val_2 string)
ID is the primary key. Does above SQL statement requires id
to be unique? If not, what should I do to modify
the SQL statement? What should I do to add a
foregin key in above statement?
Thanks so much.
+Pie Number of slices to send: Send
John, to create a Primary key you can use the ALTER command in your existing table by doing the following:
ALTER TABLE my_table ADD CONSTRAINT pk_id PRIMARY KEY (id)
If you are going to DROP the TABLE and start again use this:
CREATE TABLE my_table (
id NUMBER(10,0) NOT NULL,
val_1 NUMBER(4,0) NOT NULL,
val_2 VARCHAR(12) NOT NULL,

CONSTRAINT pk_id
PRIMARY KEY (id));
As far as the FORIEGN KEY is concerned you must reference another table.
Take a look at the following link for references and examples:
http://cisnet.baruch.cuny.edu/holowczak/classes/4300/week9.html
I hope this helps!
They gave me pumpkin ice cream. It was not pumpkin pie ice cream. Wiping my tongue on this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 1928 times.
Similar Threads
Auto Increment ID Field Table in the Oracle Database
Hibernate - Legacy Database Question
JOIN syntax for HQL . Need help!
Uploading file in a database
update while doing save in hibernate
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 19, 2024 08:02:18.