vcavusoglu
Programmer
Hi.
i have got a lot of database my customers.
some tables field type must be change
(94 field in 15 table)
I want to write pratical sql script.
change : int field to money field
how ?
i try it.
"Alter Table TABLE1 Alter column FIELD1 money" is not running
a error message
Server: Msg 5074, Level 16, State 1, Line 1
The object 'DF_HAT_FIELD1' is dependent on column 'FIELD1'.
Server: Msg 4922, Level 16, State 1, Line 1
ALTER TABLE ALTER COLUMN FIELD1 failed because one or more objects access this column.
i have got a lot of database my customers.
some tables field type must be change
(94 field in 15 table)
I want to write pratical sql script.
change : int field to money field
how ?
i try it.
"Alter Table TABLE1 Alter column FIELD1 money" is not running
a error message
Server: Msg 5074, Level 16, State 1, Line 1
The object 'DF_HAT_FIELD1' is dependent on column 'FIELD1'.
Server: Msg 4922, Level 16, State 1, Line 1
ALTER TABLE ALTER COLUMN FIELD1 failed because one or more objects access this column.