Home » RDBMS Server » Server Administration » create table ...
create table ... [message #373663] Mon, 30 April 2001 16:09 Go to next message
padma
Messages: 22
Registered: April 2001
Junior Member
At SQL prompt, trying to create a table with the foll. syntax -
create table mytable (propertyid not null varchar(20), firstname varchar(20), lastname varchar(20), submit date)

But I keep getting error message - )R-00922: missing or invalid option.

What am I doing wrong ?

Thanks,
padma

Report message to a moderator

Re: create table ... [message #373666 is a reply to message #373663] Tue, 01 May 2001 04:22 Go to previous message
Ramanarsaiah Katam
Messages: 4
Registered: May 2001
Junior Member
try this:
create table mytable (propertyid varchar(20) not null, firstname varchar(20), lastname varchar(20), submit date)

Report message to a moderator

Previous Topic: create table ...
Next Topic: SQL Query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 00:24:20 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.