Get information about foreign keys used in a table.

Get information about foreign keys used in a table.

How can I get information about foreign keys used in a table?

View Answers

November 15, 2010 at 4:42 PM

Hi friends,

DatabaseMetaData.getImportedKeys() returns a ResultSet with data about foreign key columns, tables, sequence and update and delete rules.

Thanks.









Related Tutorials/Questions & Answers:
Get information about foreign keys used in a table.
Get information about foreign keys used in a table.  How can I get information about foreign keys used in a table
get information about foreign keys - JDBC
get information about foreign keys  How to get the information about foreign keys in Java
Advertisements
I determine where a given table is referenced via foreign keys.
I determine where a given table is referenced via foreign keys.  How can I determine where a given table is referenced via foreign keys
Foreign key update table
Foreign key update table  How to update table that has the foreign key in SQL..?   ALTER TABLE YourTable ADD CONSTRAINT FK_YourForeignKey FOREIGN KEY (YourForeignKeyColumn) REFERENCES YourPrimaryTable
how tohow to create a table with primary key and foreign keyhow to create a table with primary key and foreign key
how tohow to create a table with primary key and foreign keyhow to create a table with primary key and foreign key  how to create a table using java language with primary key and foreign key   Hi Friend, A foreign
Mysql Alter Foreign Key
of another  table. The use of the foreign key is used to ensure referential... create table is used to create a table book with required fieldname and data type... table Book Add Foreign Key contraint: mysql> describe book
alter table add foreign key mysql
alter table add foreign key mysql  Hi, How to add foreign key in mysql using the query 'alter table add foreign key mysql' Thanks   Hi, We can use the following query: ALTER TABLE emp_address ADD FOREIGN KEY (emp_id
Description of Database Table
by the database. By using a simple query we can get all information about the table...;  This section introduces you how to get the detailed information about the database table. As we all know that, table has some specific information
information about scjp
information about scjp  fees details abou scjp? what are the best books for preparing to scjp. how many time scjp exam's are conducted for one year
List Information about folder
List Information about folder       This Example shows you how to show folder information. In this code we have used method of Folder class to retrieve information about
get information from database
get information from database  get information from database   Please visit the following links: http://www.roseindia.net/sql/mysql-table/mysql-php-select.shtml http://www.roseindia.net/sql/mysql-example/select
I want detail information about switchaction? - Struts
I want detail information about switch action?  What is switch action in Java? I want detail information about SwitchAction
Get All Keys and Values of the Properties files in Java
Get All Keys and Values of the Properties files in Java... to get all keys and it's values of the properties files in Java. Java provides.... The properties files that can be used to large collections of information
PHP Get Browser Information
PHP Get Browser Info PHP provides us  $_SERVER['HTTP_USER_AGENT'] function is used to display the browser information Code for PHP Get Browser Info:ADS_TO_REPLACE_1 <?php echo $_SERVER['HTTP_USER_AGENT'] . "\n\n"
why get method is used?
why get method is used?  why get method is used in 60% commercial application while using post is more secure
Getting information about Constructor
Getting information about Constructor       In this section you will learn, how to retrieve the information about the constructor by using the getConstructors() method. Here is an example
Get Column Count using ResultSet in SQL
Get Column Count using ResultSet in SQL    This example counts the number of columns in a table. The ResultSetMetaData interface can be used to get type and properties information
Foreign key in mysql
, there are foreign keys in some of the tables - does anyone know how to link the foreign key of one table into another table within phpmyadmin so the database...Foreign key in mysql  Hi I am creating a website and linking
Get All Keys and Values of the Properties files in Java
Get All Keys and Values of the Properties files in Java... to get all keys and values of the properties files in the Java. This section...:ADS_TO_REPLACE_1 Here, you will get all keys and values of the properties files
How To Get the Uploaded File Information in the Receiving Script?
How To Get the Uploaded File Information in the Receiving Script?  How To Get the Uploaded File Information in the Receiving Script
Know About Outsourcing, More About Outsourcing, Useful Information Outsourcing
Everything you need to Know about Outsourcing Introduction Let us start at the beginning with a definition of what is outsourcing. Outsourcing can... on core competencies and get peripheral tasks accomplished by a third party
How to retrive database information using servlet and disply in table format in browser
How to retrive database information using servlet and disply in table format in browser  Hi, any one send code how to retrive the data base information in table format in web browser
MySQL Create Table
; Here, you will read the brief description about the MySQL create table. The CREATE TABLE statement is used for creating a table in database. ... about the created table then you write the following query:ADS_TO_REPLACE_5
Operating System Information
information about our operation system. In this example we are getting the OS name...): This method is used to get the system property. ... The information about OS Name of the OS: Windows 2000 Version
timezone_location_get
. Return Values Array containing location information about timezone. Example...timezone_location_get() Function in PHP timezone_location_get alias DateTimeZone::getLocation returns location information for a timezone including country
PHP GD get gd information
<?php echo '<pre> '; print_r(gd_info());ADS_TO_REPLACE_1 echo '</pre> '; ?> After running the program you will get the following output Array ( [GD Version] => bundled (2.0.34 compatible
Keys in DBMS
is a set of columns within a table that can be used to identify a particular row in a table while composite key is the combination of two or more than two keys...Keys in DBMS  Whats the main difference between composite and super
How to get Keys and Values from HashMap in Java?
How to get Keys and Values from HashMap in Java? Example program of iterating... to iterate the keys and get the values and print on the console. How to get keys... to iterate through keys and get the values. So, let's see how to iterate
foreign key error in sql
foreign key error in sql  create table matchdetails(mid varchar2(10...); ->the match tablle is created create table batsman(mid varchar2(10),pid... varchar2(10),sixes varchar2(10),primary key(mid.pid), foreign key(mid
Get Variable in PHP Video tutorial
types of variables in PHP: GET and POST in PHP, which are used to get the information from any form. To make it easier for you we will use $_GET variable... with the tutorial you will finally know about how to use GET variable in PHP easily and can
SQL get Column Name
SQL get Column Name       SQL get Column Name is used to return the Fieldnames of the table... is used to show fieldname and datatypes  from table 'Stu'.ADS
hibernate Foreign key
using set methods in orders table in feild P_Id which is foreign key. How to insert...hibernate Foreign key  sir, I am using hibernate in netbeans. I have 2 following tables CREATE TABLE persons ( P_Id int(11) NOT NULL, LastName
SimpleJdbcInsert, Retrieving auto-generated keys
SimpleJdbcInsert, Retrieving auto-generated keys The auto-generated keys can... numerical instance can be used in our domain class. SJIautokey.javaADS... executing code , the rows affected at database table "records"
Getting Information of All Available Time Zones
information about the time zones for setting up the time according... In this section, the given program shows you how to get about all... Getting Information of All Available Time Zones
PHP list array keys
array_keys() function returns the keys of the the given array. It returns the keys in the form of array. Example of PHP list Array Keys <?php...;   $key=array_keys($ar1);     print_r($key); ?>
Information about Deer Park of Delhi
. The park has a large enclosed area where deer can live, wander about and play
how to use foreign key in java
how to use foreign key in java  I have two tables in my MySQL database, which were created like this: CREATE TABLE table1 ( id int auto_increment, first name varchar(10), primary key(id) ) CREATE TABLE table2 ( id_fk int, last
setting keys
setting keys  Hi Sir\Mam,At present we are doing Payroll Project .I would like to set some special keys for my forms and i want the coding to do the same .Pls Provide me source code for setting keys as soon as possible
Generate Keys
Generate Keys  hello i need code to generate key , after that send Keys to email address user. for example if you member in your website,if member not having Secret Keys not can download files if member having secret key i
Client Socket Information
Client Socket Information       In this section, you will learn how to get client socket information. This is a very simple program of java network. Here, we have
Get date data type from table
GET DATE DATA TYPE FROM TABLE In this example , we will get "Date" data type from a table of "Mysql" database and it also display current "date". And it will also display time elapsed in Milliseconds 
Java program to get column names of a table
Java program to get column names of a table... the manipulation on the table related information. ResultSetMetaData rsmd ... names we need to have connection with the database and then after we will get
PHP How to Create Table
PHP Create Table: In every database we need to create table, tables... are the collection of columns. Suppose that we want to store data about.... Now if we combine these attributes in a meaningful manner then we can get
Mysql Alter Table Syntax
;  Mysql Alter Table is used to redefine the existing table...'. The create table statement is used to create a table 'employees' with different...: The Query Alter is used to modify the table 'employees' and add keywords
crud operations with foreign key constraint.
crud operations with foreign key constraint.  I neeed to know how to perform crud operations in mysql with foreign key constraint using mvc architecture i.e using servlet jsp and bean. please provide all the code so that i can
Printing server information
is connected. Draw a table in HTML on which the server information will embossed. ...Printing server information This example will teach you how to print the server information on the screen connected to your PC. For printing the server
Detecting Duplicate Keys
Detecting Duplicate Keys  Detecting Duplicate Keys I have a program that inserts rows in a table. My table has a column 'Name' that has a unique constraint. If the user attempts to insert a duplicate name into the table, I want
Get "Schema" of a table using "ResultSetMetaData"
GET "SCHEMA" OF A TABLE USING "RESULTSETMETADATA"   In this section, schema of a table will be fetched by using 'Resultset'... Files\Java\jdk1.6.0_18\bin>java getschema Table Name : Emp_sal Field 
ModuleNotFoundError: No module named 'keys'
ModuleNotFoundError: No module named 'keys'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'keys' How to remove the ModuleNotFoundError: No module named 'keys' error
table
table  multiplicatyion table

Ads