Archives of the TeradataForum

Message Posted: Wed, 15 Apr 2009 @ 12:33:12 GMT

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

     SELECT DISTINCT
        INDEXNAME,
        INDEXNUMBER
     FROM
        DBC.INDICES
     WHERE
        DATABASENAME = 'MYDATABASE'
     ORDER BY
        TABLENAME,
        INDEXNUMBER
     ;

Vincent Bernard

Sr.Teradata DBA

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