Dear Sir/Madam

Can you tell me how to set default column in sql server using query
and how to change it.

I am using this query.

ALTER TABLE category
ALTER COLUMN position SET DEFAULT 'OLD'

but it is giving error
Incorrect syntax near the keyword 'SET'.

please help me
Thanks in advance

ALTER TABLE [category] ADD CONSTRAINT [DF_category_position] DEFAULT 'OLD'
FOR [position]



--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Deep" <vinodkus (AT) gmail (DOT) com> wrote