PhpStorm: Data Sources and Constraints

I'm starting to use the Data Source within PhpStorm, but I am having trouble finding the constraints.

I am connected to an Oracle 11g Release 11.2.0.2.0 database using the ojdbc6-11.2.0.1.0.jar driver.

I have tried browsing through the schema and right-clicking a table and choosing 'Generate and Copy DDL' from the context menu (doing this I'm able to get the CREATE TABLE and CREATE INDEX statements). Sequences are listed within the schema, just as tables are.

If someone could direct me to the correct place to view constraints I would appreciate it.

1 comment
Comment actions Permalink

Unfortunately constraints are not available in current implementation.
Please create a feature request in our tracker http://youtrack.jetbrains.net/.

You should be able to browse them in database console using the following query:

SELECT * FROM SYS.USER_CONSTRAINTS WHERE TABLE_NAME = "<view-name>"

or by opening SYS.USER_CONSTRAINTS table in table editor.

0

Please sign in to leave a comment.