3 Replies - 948 Views - Last Post: 30 March 2012 - 04:45 PM Rate Topic: -----

#1 Tameka  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 26-March 11

create table without constraints auto_id, auto_part

Posted 29 March 2012 - 03:37 PM

create table without constraints
auto_id
auto_part
Is This A Good Question/Topic? 0
  • +

Replies To: create table without constraints auto_id, auto_part

#2 DimitriV  Icon User is offline

  • They don't think it be like it is, but it do
  • member icon

Reputation: 584
  • View blog
  • Posts: 2,738
  • Joined: 24-July 11

Re: create table without constraints auto_id, auto_part

Posted 29 March 2012 - 03:39 PM

OK>> what have you tried while attempting this? Does it not work for you? What errors, if any, have you encountered?
Was This Post Helpful? 0
  • +
  • -

#3 e_i_pi  Icon User is offline

  • = -1
  • member icon

Reputation: 795
  • View blog
  • Posts: 1,681
  • Joined: 30-January 09

Re: create table without constraints auto_id, auto_part

Posted 29 March 2012 - 04:38 PM

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
Was This Post Helpful? 0
  • +
  • -

#4 Tameka  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 26-March 11

Re: create table without constraints auto_id, auto_part

Posted 30 March 2012 - 04:45 PM

View PostDimitriV, 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)
);

View PostDimitriV, 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)
);
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1