sql server programming: Hi
Is there any way that we can change the data type of a
column from 'image' type to 'ntext' via the ALTER TABLE
command?

No. It's well documented.


--
-oj
RAC v2.2 & QALite!
http://www.rac4sql.net



[quoted text, click to view]

As oj pointed out you can't, but it is easy to do in a few steps:

SELECT <primary_key>, image_column INTO #t FROM image_table
ALTER TABLE image_table DROP COLUMN image_column
ALTER TABLE image_table ADD image_column ntext NULL
UPDATE image_table
SET image_column = (SELECT image_column FROM #t
WHERE #t.<primary_key> = image_table.<primary_key>)

--
Jacco Schalkwijk MCDBA, MCSD, MCSE
Database Administrator
Eurostop Ltd.


[quoted text, click to view]