[Tameka]

create table without constraints
auto_id
auto_part

[DimitriV]

OK>> what have you tried while attempting this? Does it not work for you? What errors, if any, have you encountered?

[e_i_pi]

Hmm, I can see a few small errors with your syntax.

Firstly, 'constraints' is not a keyword in any common *SQL dialect, so that's likely to generate an error. Also, you'll need to wrap your column list in brackets, and define (at the very least) the datatypes of the columns, otherwise your query will fail.

HTH

[Tameka]

DimitriV, on 29 March 2012 - 03:39 PM, said:

OK>> what have you tried while attempting this? Does it not work for you? What errors, if any, have you encountered?

This is what I came up with
create table auto usage
(auto_id number(8),
part_id number (8)
);

DimitriV, on 29 March 2012 - 03:39 PM, said:

OK>> what have you tried while attempting this? Does it not work for you? What errors, if any, have you encountered?

This is what I came up with
create table auto usage
(auto_id number(8),
part_id number (8)
);