Default values with create table command

[lizzarrd]

Hi,

am still new at this SQL jazz. Just wanted to know how I would put default values into fields when using the CREATE TABLE command. here's the very simple code, I need to make the default 'COLOUR' 'blue', any ideas???

CREATE TABLE MODEL
(COM_MODEL CHAR(5) PRIMARY KEY,
COLOUR CHAR(10),
COST CURRENCY NOT NULL);


BTW, this is being done in MS ACCESS.

thanks in advance

[MAK]

I dont think you can do that with DDL statement.

[vagreaty]

Hi,

This is possible.

CREATE TABLE MODEL
(
COM_MODEL CHAR(5) PRIMARY KEY,
COLOUR CHAR(10) default ('BLUE'),
COST CURRENCY NOT NULL
);

Thanks

M. Antony Gubert.

[MAK]

Syntax error in create table statement.

[vagreaty]

Hi,

The above syntax is for Oracle database.
Not for MS Access.

Thanks

M. Antony Gubert.

[MAK]

but requirement is in MS-Access.