Dependent views

Database
N/A

Dependent views

Hi,

I am changing one of the table definitions(adding a couple of fields to it).Due this there would be a impact on the views that use this table.

My question is how do I find all the view that use this table.

Please let me know.

Regards,
Major

1 REPLY
Teradata Employee

Re: Dependent views

Hello,

It depends on the way you have implemented the views. If you have given specific column names in views, adding more columns will not impact them.

In other case, you can use DBC.Columns (to get column names of the changed table), DBC.TVM (to get views) and DBC.TVFields (to get columns of table or views - most likely option) to get the desired result.

Regards,

Adeel