Hello friends,
I want to add new column to an existing table in Microsoft Access database with default value to be set.
I tried the following query,
Code:ALTER TABLE Customers ADD COLUMN runno NUMBER DEFAULT 0;
This is not executing.
In MSDN its mentioned:
"The DEFAULT statement can be executed only through the Access OLE DB provider
and ADO. It will return an error message if used through the Access SQL View
user interface"
Is there any way to achieve this?
Thanks,
Rajesh.S