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

ALTER TABLE <table_name>
ADD CONSTRAINT <fk_name> FOREIGN KEY (column_name)
REFERENCES <table_name_where_this_column_acts_as_PK>
(Column_name)

Is This Answer Correct ?    19 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How is a PL/SQL code compiled?

1171


Write a unique difference between a function and a stored procedure.

924


What is primary key secondary key alternate key candidate key?

979


What is null in pl/sql?

1022


Which version of sql do I have?

995


What is the limitation on the block size of pl/sql?

936


What do you understand by pl/sql records?

959


write an sql query to find names of employee start with 'a'? : Sql dba

965


If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3944


Enlist the characteristics of pl/sql?

1740


Define sql delete statement.

953


What do you understand by pl/sql cursors?

1018


What is the benefit of foreign key?

960


what is a database? : Sql dba

1097


What do you understand by exception handling in pl/sql?

961