How to find if a column is referenced in a computed column?

by Zikato   Last Updated April 25, 2019 12:06 PM

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,
  • Indexes,
  • Check constraints,
  • Rules,
  • 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.



Related Questions


Updated April 30, 2018 20:06 PM

Updated March 12, 2018 08:06 AM

Updated August 18, 2015 18:02 PM

Updated May 15, 2015 03:02 AM

Updated June 04, 2016 08:02 AM