Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
c_o
Starting Member
6 Posts |
 Posted - 2004-11-18 : 05:42:45
|
I have a table, and I want to add a new column in a table with DEFAULT VALUE as int or text format by using Microsoft Access.i did use the code below: alter table mytbl add default 100 for col1 but it show me the error in 100, with "Syntax error in field definition"may i know where am i wrong?anybody can help???  |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-18 : 14:11:26
|
| You should probably post this question in the Access forum.Tara |
 |
|
|
mk_garg20
Constraint Violating Yak Guru
343 Posts |
Posted - 2004-11-18 : 19:27:28
|
| That you can do from design view as well.mk_garg |
|
|
|
|
|
|
ADD Field as DEFAULT in MS Access