database - How to set the default value of an Access 2003 field using SQL? -
How can I set the default value for a field using SQL in MS Access?
I tried it but found a syntax error:
create the table hello (mind intener faucet, add cher (50) default t 16 AD ST. / Code>
The word ADD is a keyword. Try it:
Make Table Halo (Mind Integer Faucet, [ADD] CHAR (50) Default '16 ASD ST.')
< / Html>
Comments
Post a Comment