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

What is int identity in sql?

1059


How can one get sql*loader to commit only at the end of the load file? : aql loader

1004


How many postgresql users are there, worldwide?

992


What is a system versioned table?

928


What is a unique key and primary key and foreign key?

918


How run sql*plus commands that are stored in a local file?

975


How many sql commands are there?

1071


What is the difference between union and union all command?

1007


What is the difference between a database and a relational database?

1034


What is rename in sql?

915


How do I pipe the output of one isql to another?

943


Explain what is dbms?

985


How to return an array from java to pl/sql?

1061


How is pl sql different from sql?

1010


What is cost in sql execution plan?

903