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

how to see the create table statement of an existing table? : Sql dba

1007


how do you know if your mysql server is alive? : Sql dba

1078


How can I tell if sql is running?

1064


How can triggers be used for the table auditing?

1068


Can we join more than 2 tables in sql?

1015


What is before and after trigger?

955


Can we change the table name in sql?

937


What is raw datatype in sql?

1042


Determine if oracle date is on a weekend?

1038


How do I run a pl sql procedure in sql developer?

968


Explain the rollback statement?

1004


What is pl/sql table? Why it is used?

1033


what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1127


Is sql scripting language?

1049


How is use pl and sql?

1059