create table and specify a default value

[jmarr02s]

Is it possible to create the customer table and specify a default
value?

Here is the SQL code I am using in MS Access.

CREATE TABLE customer
(First_Name char(50),
Last_Name char(50),
Address char(50) default 'Unknown',
City char(50) default 'Mumbai',
Country char(25),
Birth_Date date)

Thanks!,

jmarr02s

[Allen Browne]

See:
http://allenbrowne.com/func-DDL.html#CreateTableDDL

The example illustrates using DEFAULT.
Note that it executes under ADO.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"jmarr02s" <jo***********@illinois.govwrote in message
news:11**********************@y80g2000hsf.googlegr oups.com...

Is it possible to create the customer table and specify a default
value?

Here is the SQL code I am using in MS Access.

CREATE TABLE customer
(First_Name char(50),
Last_Name char(50),
Address char(50) default 'Unknown',
City char(50) default 'Mumbai',
Country char(25),
Birth_Date date)

Thanks!,

jmarr02s