Addition of constraint during creation of table

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 Received on Thu Nov 27 2003 - 20:51:20 CET