The following SELECT statement displays index information for all the tables in the Personnel database:
SELECT TableName,ColumnName,ColumnPosition,IndexType,UniqueFlag FROM DBC.Indices WHERE DatabaseName = ’Personnel’ ORDER BY TableName,ColumnPosition ;
Result:
TableName ColumnName ColumnPosition IndexType UniqueFlag ---------- ---------- -------------- --------- ---------- Charges Proj_id 1 S N Charges EmpNo 1 P N Charges Proj_id 2 P N Department DeptNo 1 P Y Employee EmpNo 1 P Y Employee Name 1 S N Project Proj_id 1 P Y