SQLDictionary dict;
DictTable dictTable;
;
while select dict
where dict.fieldId == 0 // only tablenames
{
dictTable = new DictTable(dict.tabId);
if ( dictTable.indexCnt() == 0 && ! dictTable.isView() )
{
info(strfmt("Table %1 has no indexes", dictTable.name()));
}
}
No comments:
Post a Comment