Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How do I find the columns that depend on a specified CLR user-defined type or alias type?

April 26, 2017Alias clr columns depend type User-defined

0

Posted

How do I find the columns that depend on a specified CLR user-defined type or alias type?

1 Answer

0

Posted

Before you run the following query, replace with a valid name and with a valid, schema-qualified CLR user-defined type, or schema-qualified alias type name. The following query requires membership in the db_owner role or permissions to see all dependent column and computed column metadata in the database.