How to modify a column using SQL.

[Ashish Kumar]

Can anyone suggest the SQL syntax on MS SQL Server (6.5) to modify
attributes of a column (Anything, say Not Null to Null property). I
can not use the Enterprise Manager for my requirements.

For example: Oracle supports the following syntax.

alter table <table> modify <column> .......

Thanks in advance.

[Ben McEwan]

In article <3343C3...@jagat.com>, From Ashish Kumar
<kum...@jagat.com>, the following was written:

This is not supported under 6.5. Alter table allows only the addition of
nullable columns. To accomlish this you must recreate the table with the
new defintion, rebuild indexes, and move the data over.

--
04/03/97 12:57
Ben McEwan
Geist, LLC - http://www.metis.com/~geist
bmc...@metis.com.

[Farhad "Fred" Amirfaiz]

Also look at Visual Interdev. The database portion of this tool allows
changing of column names and attributes. (Under the hood, it writes a
lengthy script, then executes it.) BTW, save the script for later use!

Look at www.microsoft.com/vinterdev under evaluator's guide.