I'm trying to mass retype columns. That means first dropping and recreating any constraints they are part of.
I found columns referenced by these constraints
- Foreign Keys,
- Primary Keys,
- Check constraints,
- Default constraints.
But I cannot find Computed columns.
I've looked into
INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE, but it doesn't include Computed Columns.
There is also
sys.computed_columns which shows definition, but doesn't list columns in searchable manner.
Is there anywhere else I can look? If SQL Server can figure out the dependence, I thought I would be able to as well.