ALTER TABLE column with default value

  • Thread starter Thread starter Francesco Sarzana
  • Start date Start date
F

Francesco Sarzana

hi,

i want to add a new column in a MS ACCESS database with a default value.

is this statement wrong?:

ALTER TABLE xxx ADD colyy INTEGER DEFAULT 0

cause i get this error:

Microsoft OLE DB Provider for ODBC Driverserror '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE
statement.


can anyone help me???
 
This syntax may only be supported by the Microsoft Jet OLE DB Provider (not
the Microsoft OLE DB Provider for ODBC).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set default value to 0 with ALTER TABLE 1
Making SQL updates to a table named 'COLUMN' 3
ALTER TABLE problems 5
ALTER COLUMN question 1
Changing the default value of a column in Access using a SQL query 1
add a value to a date 8
SQL Change Column name 5
alter table and order by 1

Back
Top