Adding a boolean type field to a table using SQL

Question

I'm trying to add a boolean field to a table using SQL however I'm not getting anywhere. The query I am using to try and add the field is:

ALTER TABLE TEST
ADD "NewField" BOOLEAN

When running this it will display the error Invalid use of keyword. I'm trying to add this field to a paradox database.

Any help would be appreciated.

What SQL engine? Oracle, MS SQL Server, DB2, MySQL, Postgresql etc? — xQbert
– xQbert, Commented May 15, 2012 at 19:36

Bridge · Accepted Answer · 2012-05-15 19:29:49Z

5

There is no Boolean in SQL - use a bit column instead.

answered May 15, 2012 at 19:29

Bridge

30.9k10 gold badges64 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

sam yi · Accepted Answer · 2012-05-15 19:55:57Z

0

double quote = postgres? The table names with capital letters may need double quotes as well.

alter table "TEST" add "NewField" boolean;

may work....

answered May 15, 2012 at 19:55

sam yi

4,9451 gold badge33 silver badges41 bronze badges