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 CONSTRAINT constraint_name PRIMARY KEY(column_name);
ALTER TABLE myschema.kategori
ADD CONSTRAINT pkkategori
PRIMARY KEY (kategoriid)
USING INDEX
TABLESPACE etiket_idx;
Friday, April 17, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment