Get information about foreign keys used in a table.

Ads

 
 

Share on Google+Share on Google+

Clark
Get information about foreign keys used in a table.
1 Answer(s)      6 years and 10 months ago
Posted in : JDBC

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

Ads
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.


Ads









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... from 'Mysql Alter Foreign Key'. To understand with example we create a table... to create table "book": The Query create table is used to create
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
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
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
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
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
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
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 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...: Here, you will get all keys and values of the properties files with the help
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: <?php echo $_SERVER['HTTP_USER_AGENT'] . "\n\n"; ?>
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
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
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
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
Operating System Information
information about our operation system. In this example we are getting the OS name... keys: String getProperty(String key): This method is used...\rajesh\completed>java OpertingSystemInfo The information about OS
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
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
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
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
PHP GD get gd information
<?php echo '<pre> '; print_r(gd_info()); echo '</pre> '; ?> After running the program you will get the following output Array ( [GD Version] => bundled (2.0.34 compatible) [FreeType Support
SQL get Column Name
SQL get Column Name       SQL get Column Name is used to return the Fieldnames of the table... get Column Name'. To understand and elaborate example we create a table 'stu
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
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...) or the economies of scale. A decision to focus on core competencies and get
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. ...)); If you want to know about the created table then you write the following query
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