Search code examples
database-connectionphpstormsap-iq

PhpStorm tables displaying database setting


I connect to Sybase IQ database via PhpStorm. End I have a tables explorer at database tool window.

What I need is to make tables names display like schema_name.table_name, not just the table name. Seems like I can achieve it in database driver settings, but don't know what should I do exactly. There is a setting in database connection window where I can choose such setting in AquaData studio.


Solution

  • AFAIK it's not possible to have schema_name.table_name -- only db_name.schema_name.table_name.

    For this just enable "Flatten Schemas" option (under "cog" icon or via right click on tool window title/label).

    P.S. Cannot say anything about database driver settings for Sybase.