>Hi everybody,
>
>Suppose, we change one of our tables and convert datetime fields to date fields. How would we know, which views are affected by this change? If we have lots of them (~70), is there some automatic way to identify the suspects?
>
>Thanks a lot in advance.

cTableName = [%MyTable%]
SET EXCLUSIVE OFF
lcDBC = [MyDBC.DBC]
SELECT ObjectType, ObjectName ;
	FROM (lcDBC) A ;
	WHERE A.ObjectType = 'View' ;
	  AND A.ObjectID IN ;
	  (SELECT ParentID FROM (lcDBC) B ;
	  	WHERE LOWER(Property) LIKE ?LOWER(cTableName)) ;
	INTO CURSOR crsAffectedViews