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

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

html - CSS autoheight, but fit content to height of div -

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -