The syntax for sql server is:
ALTER TABLE Tablename ALTER Columnname NewDataType
John
Klaus Sonnenleiter wrote:
>
> ALTER TABLE Courses MODIFY Audience_ID NUMBER(10,2);
>
> This is the syntax for Oracle. Modify on columns was not supported in older
> versions of SQL Server if I remember correctly, but I think they added it -
> if not, you may have to change it in the GUI.
>
> Klaus
>
> On Thursday 09 May 2002 09:34, Dan Stein wrote:
> > I want to alter a column data type from char to numeric
> >
> > From the help file I can't figure out the syntax
> >
> > Table name
> > Courses
> >
> > Column name
> > Audience_ID
> ________________________________________________________________________
> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
> with unsubscribe witango-talk in the message body
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
