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
How is a PL/SQL code compiled?
Write a unique difference between a function and a stored procedure.
What is primary key secondary key alternate key candidate key?
What is null in pl/sql?
Which version of sql do I have?
What is the limitation on the block size of pl/sql?
What do you understand by pl/sql records?
write an sql query to find names of employee start with 'a'? : Sql dba
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????
Enlist the characteristics of pl/sql?
Define sql delete statement.
What do you understand by pl/sql cursors?
What is the benefit of foreign key?
what is a database? : Sql dba
What do you understand by exception handling in pl/sql?