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

Filed under:
|

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

Related posts about sql

Related posts about Oracle