Why DB constraints are not added during table creation.
Posted
by Pratik
on Stack Overflow
See other posts from Stack Overflow
or by Pratik
Published on 2010-03-19T10:02:21Z
Indexed on
2010/03/19
10:21 UTC
Read the original article
Hit count: 309
Hi All,
What is the difference between these to ways of table creation.
CREATE TABLE TABLENAME(
field1....
field2...
add constraint constraint1;
add constraint constraint2;
)
AND
CREATE TABLE TABLENAME(
field1....
field2...
)
ALTER TABLE TABLENAME add constaint1
ALTER TABLE TABLENAME add constaint2
Moreover the first scripts fails on the SQL+ but they pass on sqldeveloper Thanks! Pratik
© Stack Overflow or respective owner