Modifying Tables With Unitext Columns

Restrictions that apply when you use alter table to modify unitext columns.

  • You can add a new unitext column that accepts NULL values.

  • You can modify a column from unitext only to the following datatypes:
    • [n]char

    • [n]varchar

    • unichar

    • univarchar

    • binary

    • varbinary

  • You cannot modify a column to the unitext datatype.

  • You cannot add a unitext column and drop an existing unitext column in the same statement.