Hi All,
I have few tables (abc, def) with with a specific structure and I need
to add constratint to the table I do it with
alter table abc
add constraint abc_columnname_fk
foreign key (columnname) references dec(columnname);
But my question is how to create a table with this constraint embedded
in the create table statement itself ? same, as in
CREATE TABLE abc
(columna PRIMARY KEY,
Column2 CHAR(50) ???????????? );
Can I embed the constraint during creation of the table only ?
Can somebody please throw light or solution
I am stuck with this problem.
Thanks in advance,,
PK