Each row in the SYSFOREIGNKEYS view describes one foreign key for each table in the catalog.
The tables and columns that make up this view are provided in the SQL statement below. To learn more about a particular table or column, use the links provided beneath the view definition.
ALTER VIEW "SYS"."SYSFOREIGNKEYS"( foreign_creator, foreign_tname, primary_creator,primary_tname,role,columns ) as select fk_up.user_name,fk_tab.table_name,pk_up.user_name, pk_tab.table_name,ix.index_name, (select list(string(fk_col.column_name,' IS ', pk_col.column_name)) from SYS.ISYSIDXCOL as fkc join SYS.ISYSTABCOL as fk_col on( fkc.table_id = fk_col.table_id and fkc.column_id = fk_col.column_id) ,SYS.ISYSTABCOL as pk_col where fkc.table_id = fk.foreign_table_id and fkc.index_id = fk.foreign_index_id and pk_col.table_id = fk.primary_table_id and pk_col.column_id = fkc.primary_column_id) from SYS.ISYSFKEY as fk join SYS.ISYSTAB as fk_tab on fk_tab.table_id = fk.foreign_table_id join SYS.ISYSUSER as fk_up on fk_up.user_id = fk_tab.creator join SYS.ISYSTAB as pk_tab on pk_tab.table_id = fk.primary_table_id join SYS.ISYSUSER as pk_up on pk_up.user_id = pk_tab.creator join SYS.ISYSIDX as ix on ix.table_id = fk.foreign_table_id and ix.index_id = fk.foreign_index_id |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |