Problem with view

[GeertVerhoeven]

Hi all,

I've altered a table (DIM_TIME) by adding an extra column.
Apparently there are multiple views that do a SELECT * FROM DIM_TIME.

The problem is that by adding the column, the views are mixed up.

Is there a possibility to reprocess all the views based on a specific table ?
Or is there a way to look which views are using a specific table.

Cause now I'm recreating all the views to be sure that I didn't skipped one.

Thanks in advance !

Geert

 

[Jamfool]

to see where a table is referenced:

select sc.text, sc.id, so.name, so.type
from syscomments sc inner join sysobjects so
on sc.id = so.id
where text like '%' + 'specifictable' + '%'