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

how to do backup entire database? : Transact sql

1137


What is trigger in sql?

1086


How many databases can sql express handle?

978


How can you fetch first 5 characters of the string?

1010


Is sql pronounced sequel or sql?

1260


Explain foreign key in sql?

1018


How to avoid duplicate records in a query?

1003


Is the primary key an index?

1024


How do I view a table in sql?

1001


How do I kill a query in postgresql?

1098


Can we use pl sql in sql server?

1079


Explain normalization and what are the advantages of it?

947


What is data manipulation language?

1183


What is the difference between Union and Union all. Which is faster.

1401


Why do we create stored procedures & functions in pl/sql and how are they different?

937