Archives of the TeradataForum

Message Posted: Tue, 16 Jan 2007 @ 14:18:48 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Is there an easy way (DBC query or otherwise) to find out if a view is invalid or valid?

Try

     EXPLAIN SELECT COUNT(*) FROM mydatabase.myview ;

You will get an error if the view is invalid.

Ralph Daugherity


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Archives

2007 Indexes

Last Modified: 15 Jun 2023