help..CREATE TABLE statement

Results 1 to 2 of 2

Thread: help..CREATE TABLE statement

  1. #1
    Join Date
    Dec 1969

    Default help..CREATE TABLE statement

    hi im using an access database... how do i create a table with a BOOLEAN field using SQL? does anyone know wot the syntax is?<BR><BR>thanks a lot<BR>zain

  2. #2
    Join Date
    Dec 1969

    Default My docs say BOOLEAN...

    CREATE TABLE whatever ( flag BOOLEAN, ... )<BR><BR>The docs say that the JET engine accepts <BR> BOOLEAN<BR> LOGICAL<BR> LOGICAL1<BR> YESNO<BR> BIT<BR>as synonyms. BIT is the primary name, but the others are all supposed to be equivalent.<BR><BR><BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts