 |
 |
Archives of the TeradataForum
Message Posted: Sat, 12 Oct 2002 @ 10:46:01 GMT
| Subj: | | Re: Find name of Join Index |
| |
| From: | | Dieter Nöth |
| | Can anyone tell me how to find the name of any Join Indexes that are defined to/for a given table? | |
| | I can tell that they exist by looking in DBC.Indexes, but I need to find the index name (as used in CREATE JOIN INDEX
???). | |
You're looking for the wrong system table:
select * from dbc.tables
where TableKind = 'I';
Dieter
| |
