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 / subbu

You cannot add foreign key after creation of the table until
unless you have assigned the primary key while creating the
table. I mean without a primary key assigned for a table, we
cannot add foreign key.

Once the primary key is found, then query to add is been
already given by the above posters.

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is sql developer case sensitive?

943


How do you delete data from a table?

974


Is sqlite free?

907


What is int identity in sql?

1059


What is tuple in sql?

1005


What is indexes?

999


How do I debug a stored procedure?

1038


How do we use distinct statement? What is its use?

975


How do you concatenate in sql?

972


What are the advantages of pl sql?

1070


Which data dictionary views have the information on the triggers that are available in the database?

1179


How many types of literals are available in pl sql?

1045


what does the t-sql command ident_incr does? : Transact sql

1009


What are the advantages of sql?

1005


What does (+) mean in sql joins?

1010