Interested to Buy Any Domain ? << Click Here >> for more details...
How to add Foreign key in a table after the creation of the
table?
- 5 Answers
- 11560 Views
- Satyam, I also Faced
- E-Mail Answers
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
What is an inconsistent dependency?
What is rename command in sql?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
What is rownum?
What are the two virtual tables available at the time of database trigger execution?
what is rdbms? : Sql dba
is mysql query is case sensitive? : Sql dba
What is program debugging?
What is the maximum number of triggers, you can apply on a single table?
Can dml statements be used in pl/sql?
Write a sql query to convert all character to uppercase after hypen.
Which constraints we can use while creating database in sql?
what is the difference between sql and t-sql? : Transact sql
What are the different types of database management systems?
What is the difference between function and procedure in pl/sql?
