removing schema from typed xml

• thecodeguys

  Ten Centuries

  Points: 1076

  More actions

  October 10, 2008 at 12:00 pm

  #125202

  So to move an untyped xml column to typed I run the following

  alter table

  alter column ColumnName xml (dbo.SchemaName)

  How do I go the other way.

  Running the following errored out.

  alter table

  alter column ColumnName xml

• jacob sebastian

  SSChampion

  Points: 11822

  More actions

  October 11, 2008 at 2:47 am

  #883731

  You need to specify the table name after "alter table". For example:

  create table schematest (data xml(ElementTest))

  go

  alter table schematest alter column data xml

  .