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
What is oracle sql developer?
Is like operator in sql case sensitive?
Can we use joins in subquery?
Is left join faster than inner join?
What is sql character function?
What is parallel hint?
Can we use commit inside a trigger?
How to execute a stored procedure?
what is oltp (online transaction processing)? : Sql dba
What port does sql server use?
What are the types of subqueries?
what is cross join? : Sql dba
How many types of cursors supported in pl/sql?
Can unique keys be null?
Is a secondary key the same as a foreign key?