Hi
i need to modify datatype
create Table mytable(i int,j datetime default getdate());
Alter Table mytable ALTER COLUMN J As dbo.myfunction1();
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'As'.
where as if i create a table with the user defined datatype i am able to create the table.
create Table mytable1(i int,j As dbo.myfunction1());