Friday, April 17, 2009

Create table with primary key constraint

Template:
CREATE TABLE myschema.table_name
(
col1 dataType,
col2
dataType,
col...
dataType ,
CONSTRAINT Constraint_name PRIMARY KEY(column_Name)
);



Example:
CREATE TABLE myschema.judulvideo
(

videotittleid NUMBER(5),

videotittlename VARCHAR2(50),

kategoriid NUMBER(5),
description VARCHAR2(50),
CONSTRAINT pkjudulvideo PRIMARY KEY(videotittleid)
);


Or the Other way, you can try this
First, create the table
CREATE TABLE myschema.table_name
(
col1 dataType,
col2
dataType,
col...
dataType ,
);


CREATE TABLE kategori
(
kategoriid NUMBER(5),
katoriname VARCHAR2(30),
description VARCHAR2(50)
)
TABLESPACE etiket_tbl;


Then Alter the table to add the primary key constraint
ALTER TABLE
myschema.table_name
ADD CON
STRAINT constraint_name PRIMARY KEY(column_name);

ALTER TABLE myschema.kategori
ADD CONSTRAINT pkkategori
PRIMARY KEY (kategoriid)
USING INDEX
TABLESPACE etiket_idx;


No comments:

Post a Comment