Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How to add Foreign key in a table after the creation of the
table?

Answer Posted / venkatesh

u have create two tables an the time one in first table must an should using primary key .in way of using ddl cmd.
A)alter table table name add fk(clm name) reference column name from table name consists of primary key

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the uses of a database trigger?

1043


What is the usage of the distinct keyword?

1220


What is a primary key sql?

1041


Who is the owner of mysql database?

1057


What is the maximum number of columns in sql table?

1169


What is data abstraction in sql?

1029


What is set serveroutput on in pl sql?

1293


how would you enter characters as hex numbers? : Sql dba

983


Enlist the characteristics of pl/sql?

1801


What are the key differences between SQL and PL SQL?

1211


how many sql dml commands are supported by 'mysql'? : Sql dba

1120


what are the different index configurations a table can have? : Sql dba

995


What are sql commands?

1010


What is sql stand for?

983


List the different type of joins?

1061