I'm trying to create at table that inserts a default value into a field if
nothing is supplied. If in interpret the documentation correctly this should
be accomplished by something like this:
CREATE TABLE Location (LocationID VARCHAR(10) NOT NULL PRIMARY KEY, Name
VARCHAR(50), Address1
On Sun, 2001-11-04 at 13:52, Chris Williams wrote:
I'm trying to create at table that inserts a default value into a field if
nothing is supplied. If in interpret the documentation correctly this should
be accomplished by something like this:
CREATE TABLE Location (LocationID VARCHAR(10)
,
column2, etc) value (value1, value2, etc) but don't include icon in your
list of columns and that will default it to 1.
Chris
-Original Message-
From: Chris Williams [mailto:[EMAIL PROTECTED]]
Sent: Sunday, November 04, 2001 3:52 PM
To: [EMAIL PROTECTED]
Subject: Setting a DEFAULT value