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
