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

we can add a foreign key to a table
1)while creation of table
2)After the creation of the table

by using
Alter table table_name add foreign key(column_name)
References column_name from table_name(that consists of
primary key)

Is This Answer Correct ?    7 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are field types?

998


Does view store data in sql?

961


What is a subquery in sql?

1036


How do I filter in sql profiler?

990


What is cross join sql?

916


What is file based approach?

937


what is the command used to fetch first 5 characters of the string? : Sql dba

1635


What is Collation Sensitivity ? What are the various type ?

952


What is sql mysql pl sql oracle?

1067


What is package in pl sql?

1014


What is cartesian join in sql?

1116


Explain the steps needed to create the scheduled job?

1036


What is trigger price?

984


What is sql key?

987


Is sql pronounced sequel or sql?

1260