public static Dictionary <string, TableEntity.Index> GetIndexesByTable(string tableName)
{//a.index_name,table_owner,table_name,a.uniqueness,a.tablespace_name
Dictionary <string, TableEntity.Index> indexDictionary = new Dictionary <string, TableEntity.Index>();
System.Data.DataTable indexDataTable = OracleDocument.GetIndexesByTableName(tableName);
foreach (System.Data.DataRow dataRow in indexDataTable.Rows)
{
TableEntity.Index index = new TableEntity.Index();
index.IndexName = dataRow["index_name"].ToString().ToLower();
index.TableSpace = dataRow["tablespace_name"].ToString();
index.Uniqueness = dataRow["uniqueness"].ToString();
index.Columns = GetIndexColumnByIndexName(index.IndexName);
indexDictionary.Add(index.IndexName, index);
}
return(indexDictionary);
}
