Welcome to ModelRight Sign in | Join | Help

Script Question: Can I get the "Inherits From" information about a column?

  •  11-30-2007, 2:51 PM

    Script Question: Can I get the "Inherits From" information about a column?

    Hi Folks,

    I am writing a script to find all columns which use the <default> Column domain but ran into a problem.

    Scenario: I noticed that several of my column were set to <default> as the datatype even though I did not set them to that type. Then I realized that since the datatype of the field was the same as the datatype of the <default> Column domain, the columns were being set automatically to the <default>.

    Problem: I change the <default> column domain I will also change all the columns that have been automatically linked to that column domain. Since I want these columns to not be set to <default>, I want to find all the references and set them.

    Question: I have created a script which examines each table and column but I can't seem to find a property/attribute/easter egg/magic spell, etc which contains a reference to the <default> column domain. Is there any information available to a script which will tell me the column domain for a given column?

    Thanks for the help and have a great weekend.

    Darren 

     

View Complete Thread