creating a default value via tsql

[eja2000]

i am trying to create a default value for the column activevac using the following tsql;

ALTER TABLE vacancies
alter column activevac nvarchar DEFAULT -1
----------------------------------------
but i keep on getting the following error;

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'DEFAULT'.


Can anyone help please?
thanks.i cannot do it through enterprise manager,only through query analyzer so i need a tsql solution.

 

[swampBoogie]

alter table variances add default '-1' for activevac

 

[SQLSister]

If this field is going to store numeric data and you will want to do any calculations or sorting onthe numbers, it probaly should have a data type that is numeric and not text oriented.

Questions about posting. See faq183-874

 

[eja2000]

thanks swampboogie..
it worked!

 

[eja2000]

i have an inteer field that i want to alter to be an identity field.
how can i do this?
thanks

 

[eja2000]

i have an integer field that i want to alter to be an identity field.
how can i do this?
thanks

 

[SQLSister]

thread183-859962

Questions about posting. See faq183-874