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 trigger in sql?

1110


Is sql between inclusive?

1147


How can you tell the difference between an index and a view?

941


What are different joins used in sql?

1067


What is normalisation and its types?

1015


What is materialized view in sql?

928


Is sql port 1433 encrypted?

1039


Is ms sql is free?

1032


What are the different types of a subquery?

1063


How can you save or place your msg in a table?

1009


What do you think about pl/sql?

1045


What are predefined functions in sql?

1055


Explain the difference between triggers and constraints?

989


What are the two types of exceptions in pl/sql?

1060


What are the different ddl commands in sql?

1181