Using DQL to change a type's supertype.

I would like to use DQL, such as ALTER TYPE, to change the supertype of a custom type from dm_document to dm_sysobject. How would I go about this? Cannot find an example or the proper keyword in the DQL manual...

Find more posts tagged with

Comments

msroth

Check the CHANGE...OBJECT DQL command. However, my experience is that this is never a clean and easy process.

XdctmX

The best way to do this is to recreate the type.

Wiesnoepersad

alter type is to modify a type (i.e add/drop attributes)

what you need to do:

1. create your NEW type

2. use the change ..object dql to change current objects to the new type

Find the correct syntax in dql-ref. guide