Lines Matching refs:key
1797 /** gets a description of a table's primary key columns. They
1801 <p>Each primary key column description has the following columns:
1817 <b>KEY_SEQ</b> short => sequence number within primary key
1820 <b>PK_NAME</b> string => primary key name (may be <NULL/>)
1830 each row is a primary key column description
1838 /** gets a description of the primary key columns that are
1839 referenced by a table's foreign key columns (the primary keys
1844 <p>Each primary key column description has the following columns:
1848 <b>PKTABLE_CAT</b> string => primary key table catalog
1852 <b>PKTABLE_SCHEM</b> string => primary key table schema
1856 <b>PKTABLE_NAME</b> string => primary key table name
1860 <b>PKCOLUMN_NAME</b> string => primary key column name
1864 <b>FKTABLE_CAT</b> string => foreign key table catalog (may be <NULL/>)
1867 <b>FKTABLE_SCHEM</b> string => foreign key table schema (may be <NULL/>)
1870 <b>FKTABLE_NAME</b> string => foreign key table name
1873 <b>FKCOLUMN_NAME</b> string => foreign key column name
1876 <b>KEY_SEQ</b> short => sequence number within foreign key
1880 foreign key when primary is updated:
1883 key if it has been imported
1885 <li> importedKeyCascade - change imported key to agree
1886 with primary key update
1888 <li> importedKeySetNull - change imported key to NULL if
1889 its primary key has been updated
1891 <li> importedKeySetDefault - change imported key to default values
1892 if its primary key has been updated
1901 the foreign key when primary is deleted.
1904 key if it has been imported
1906 <li> importedKeyCascade - delete rows that import a deleted key
1908 <li> importedKeySetNull - change imported key to NULL if
1909 its primary key has been deleted
1914 <li> importedKeySetDefault - change imported key to default if
1915 its primary key has been deleted
1920 <b>FK_NAME</b> string => foreign key name (may be <NULL/>)
1923 <b>PK_NAME</b> string => primary key name (may be <NULL/>)
1926 <b>DEFERRABILITY</b> short => can the evaluation of foreign key
1945 each row is a primary key column description
1953 /** gets a description of the foreign key columns that reference a
1954 table's primary key columns (the foreign keys exported by a
1959 <p>Each foreign key column description has the following columns:
1963 <b>PKTABLE_CAT</b> string => primary key table catalog (may be <NULL/>)
1966 <b>PKTABLE_SCHEM</b> string => primary key table schema (may be <NULL/>)
1969 <b>PKTABLE_NAME</b> string => primary key table name
1972 <b>PKCOLUMN_NAME</b> string => primary key column name
1975 <b>FKTABLE_CAT</b> string => foreign key table catalog (may be <NULL/>)
1979 <b>FKTABLE_SCHEM</b> string => foreign key table schema (may be <NULL/>)
1983 <b>FKTABLE_NAME</b> string => foreign key table name
1987 <b>FKCOLUMN_NAME</b> string => foreign key column name
1991 <b>KEY_SEQ</b> short => sequence number within foreign key
1995 foreign key when primary is updated:
1998 key if it has been imported
2000 <li> CASCADE - change imported key to agree
2001 with primary key update
2003 <li> SET_NULL - change imported key to NULL if
2004 its primary key has been updated
2006 <li> SET_DEFAULT - change imported key to default values
2007 if its primary key has been updated
2016 the foreign key when primary is deleted.
2019 key if it has been imported
2021 <li> CASCADE - delete rows that import a deleted key
2023 <li> SET_NULL - change imported key to NULL if
2024 its primary key has been deleted
2029 <li> SET_DEFAULT - change imported key to default if
2030 its primary key has been deleted
2035 <b>FK_NAME</b> string => foreign key name (may be <NULL/>)
2038 <b>PK_NAME</b> string => primary key name (may be <NULL/>)
2041 <b>DEFERRABILITY</b> short => can the evaluation of foreign key
2060 each row is a foreign key column description
2068 /** gets a description of the foreign key columns in the foreign key
2069 table that reference the primary key columns of the primary key
2070 table (describe how one table imports another's key.) This
2071 should normally return a single foreign key/primary key pair
2072 (most tables only import a foreign key from a table once.). They
2077 <p>Each foreign key column description has the following columns:
2081 <b>PKTABLE_CAT</b> string => primary key table catalog (may be <NULL/>)
2084 <b>PKTABLE_SCHEM</b> string => primary key table schema (may be <NULL/>)
2087 <b>PKTABLE_NAME</b> string => primary key table name
2090 <b>PKCOLUMN_NAME</b> string => primary key column name
2093 <b>FKTABLE_CAT</b> string => foreign key table catalog (may be <NULL/>)
2097 <b>FKTABLE_SCHEM</b> string => foreign key table schema (may be <NULL/>)
2101 <b>FKTABLE_NAME</b> string => foreign key table name
2105 <b>FKCOLUMN_NAME</b> string => foreign key column name
2109 <b>KEY_SEQ</b> short => sequence number within foreign key
2113 foreign key when primary is updated:
2116 key if it has been imported
2118 <li> CASCADE - change imported key to agree
2119 with primary key update
2121 <li> SET_NULL - change imported key to NULL if
2122 its primary key has been updated
2124 <li> SET_DEFAULT - change imported key to default values
2125 if its primary key has been updated
2134 the foreign key when primary is deleted.
2137 key if it has been imported
2139 <li> CASCADE - delete rows that import a deleted key
2141 <li> SET_NULL - change imported key to NULL if
2142 its primary key has been deleted
2147 <li> SET_DEFAULT - change imported key to default if
2148 its primary key has been deleted
2153 <b>FK_NAME</b> string => foreign key name (may be <NULL/>)
2156 <b>PK_NAME</b> string => primary key name (may be <NULL/>)
2159 <b>DEFERRABILITY</b> short => can the evaluation of foreign key
2176 the table name that exports the key
2182 the table name that imports the key
2184 each row is a foreign key column description
2365 the table name that exports the key