Claus Pedersen
Member³
When a user uses apply code completion to a table name, a list of the available column names are shown. Today the user can see the column name and data type, this is all thumbs up 
I have a request: can the column information be complemented with information about whether the column is a part of the primary key (P), unique key (U), foreign key (F) etc.
An example, on scott/tiger, table EMP:
If the primary key/unique key is made up of two or more columns, there are of course two or more columns marked with P/U. After the F mark, the referenced table and column name(s) are listed.
If this could also be implemented in the browser when showing tables (next to the colum names), it would be cool. Also when a table is described (window: Columns of EMP) this extra info would be cool to have.
I am aware of the fact that these types of query in the data dictionary can be quite time consuming, so this should probably be an option that can be turned on and off by the user.
I have a request: can the column information be complemented with information about whether the column is a part of the primary key (P), unique key (U), foreign key (F) etc.
An example, on scott/tiger, table EMP:
Code:
empno number(4) P
ename varchar2(10)
job varchar2(9)
mgr number(4) F (emp.empno)
hiredate date
sal number(7,2)
comm number(7,2)
deptno number(2) F (dept.deptno)If this could also be implemented in the browser when showing tables (next to the colum names), it would be cool. Also when a table is described (window: Columns of EMP) this extra info would be cool to have.
I am aware of the fact that these types of query in the data dictionary can be quite time consuming, so this should probably be an option that can be turned on and off by the user.
