May 9, 2006 at 2:22 am
iam using ms-access
iam trying to add a column "profiletype" to a table "candidatesRegistration" which will have default 0
the column will be number, the field will either having value 0 or 1
query
---------------
alter table candidatesRegistration add column profiletype number set default 0
==================
iam trying various commands none of them worked
syntax help pls, any other help suggesstions are appreciated
<a href="http://www.websolsoftware.com"> For IT jobs click here</a>
*Sukhoi*[font="Arial Narrow"][/font]
May 9, 2006 at 6:26 am
You need to post this in an appropriate forum. You've posted it in the SQL Server 7, 2000 TSQL forum.
-SQLBill
May 9, 2006 at 7:46 am
Are you using Access as the data store, or just a front end? Are you trying to do this with a pass-through query?
Why aren't you just doing this with the GUI (either Access or Enterprise Manager)?
"number" is not a valid data type in SQL Server.
I don't think I've ever used DDL in Access before. I have no idea if there are particular issues with Jet in that case.
And, finally, if your only possible values are 1 and 0, why aren't you using a bit (or yes/no) data type?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply