A
Alan Arsinow
I am working on a VC++ Windows application that uses an Access database as a
backend. I need a way to change the default value of a column using a SQL
query.
I have tried
ALTER TABLE <table_name> ALTER COLUMN <column_name> SET DEFAULT <value>
however, I get 'Syntax error in ALTER TABLE statement' and the keyword
DEFAULT is highlighted.
I have also tried
ALTER TABLE <table_name> ADD CONSTRAINT <constraint_name> DEFAULT <value>
FOR <column_name>
however, I get 'Syntax error in CONSTRAINT clause' and the keyword DEFAULT
is highlighted.
I am really hoping there's a way to do this. Any help would be appreciated.
Thanks,
Alan Arsinow
backend. I need a way to change the default value of a column using a SQL
query.
I have tried
ALTER TABLE <table_name> ALTER COLUMN <column_name> SET DEFAULT <value>
however, I get 'Syntax error in ALTER TABLE statement' and the keyword
DEFAULT is highlighted.
I have also tried
ALTER TABLE <table_name> ADD CONSTRAINT <constraint_name> DEFAULT <value>
FOR <column_name>
however, I get 'Syntax error in CONSTRAINT clause' and the keyword DEFAULT
is highlighted.
I am really hoping there's a way to do this. Any help would be appreciated.
Thanks,
Alan Arsinow