alter column statement for boolen

J

Jeffrey Howard

I am trying to create a statement that will create a boolean column, using
the alter table command/alter column. What data type is used for boolean
values? Thank you.
 
D

Dirk Goldgar

Jeffrey Howard said:
I am trying to create a statement that will create a boolean column,
using the alter table command/alter column. What data type is used
for boolean values? Thank you.
Click to expand...

In Jet SQL? BOOLEAN, BIT, LOGICAL, YESNO -- any of these should work.
 
M

Marshall Barton

Jeffrey said:
I am trying to create a statement that will create a boolean column, using
the alter table command/alter column. What data type is used for boolean
values?
Click to expand...


A97 Help tells me you can use any of these synonyms:
BOOLEAN, BIT, LOGICAL, YESNO
but if one doesn't work, try another.

I generally use YesNo or Boolean.
 
Top