The INFORMATION_SCHEMA.VIEW_TABLE_USAGE uses the sys.sql_dependencies catalog view to figure out what the objects that are used are. If a table was renamed or dropped and recreated then sys.sql_dependencies won’t be correct, and VIEW_TABLE_USAGE won’t be correct.
Try altering the view which isn’t returning correctly to rebuild the information in sys.sql_dependencies.
[kccrosser] You can also try:
<pre>exec sp_refreshview ‘viewname’;</pre>
This will cause the metadata around the view to be updated.
FYI – I also commonly use sp_refreshsqlmodule when trying to build dependency trees of stored procedures and functions. Otherwise the dependency relations are often stale and fail to reflect new compiles, drops, and alters.