Archives of the TeradataForum

Message Posted: Mon, 22 Sep 2009 @ 00:18:07 GMT

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

Here is the sample. You may add dbc.indexstats if you want to know about index.

     sel * from dbc.tables
     where (databasename, tablename) not in
     (
     sel databasename, tablename from dbc.ColumnStats
     where FieldStatistics               is not null
     );

Cheers,

Michael

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