Create table using script in ASP page

I know how to create tables using script in an ASP page except I cannot figure out the correct syntax to create a True/False table and set it to either true or false when I create it.

strSQL = "CREATE TABLE test (field yesno(1))"

strSQL = "CREATE TABLE test (field yesno(yes))"

Neither one works. Any ideas how to make the field?

Also here's another question I want to make a field name Date but it won't allow that because Date is a reserved word.

strSQL = "CREATE TABLE test (Date datetime)"

Anyway to be able to get it to create the field named Date?

adnan248999 wrote: Hmm not sure about the yes/no field but as for the field name for date try this to see if it works strSQL = "CREATE TABLE test ([Date] datetime)"

I'll give it a go, but I tried this by doing the following before

strSQL = "CREATE TABLE test ('Date' datetime)"

This created a field actually named 'Date' and included the single quote.

I think maybe that your suggestion will create a field named [Date] and include the brackets as part of the field name.

I'll give it a go and report back.

and btw, its commonly regarded as "bad practice" to use reserved words as column names, why not make it something that makes more sense?

ie/ "StartDate", "SignupDate", "CreationDate", "WhateverDate"