domain.indexes where indexname='index1' -> no result

[Former Member]

Hi,

I am working on a maxdb database installed on a linux machine. I need to check if the given index exists. For that reasons, I am executing the sql statement:

select * from domain.indexes where indexname='index1' and it says "no result"

but I know it exists from the statement select * from domain.indexes: it is visible in the result.

What might be the reason?

Thank you very much in advance,

[thomasschulz2 · Accepted solution]

Hi,

try indexname in upper case.

Regards,

Thomas

[Former Member · Accepted solution]

Hi Thomas,

I had already done it and it worked, which I find quite silly.

Thank you very much tho.

[former_member229109 · Accepted solution]

Hello,

Please review two documents:

http://maxdb.sap.com/doc/7_8/45/4f0f424e5108d2e10000000a11466f/content.htm

"A column name (column_name) identifies a column."

http://maxdb.sap.com/doc/7_8/45/45dcf3ca6c5b41e10000000a1553f6/content.htm

About Identifier (identifier) type.

It's NOT silly. As you could use upper and low case letters for the column name,

the correct statement is :

select * from indexes where INDEXNAME='index1'

And you could run:

  select * from columns where TABLENAME = 'INDEXES'

and see the names of columns in this table.

Regards, Natalia Khlopina