How to add Foreign key in a table after the creation of the
table?
- 5 Answers
- 10756 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / subbu
You cannot add foreign key after creation of the table until
unless you have assigned the primary key while creating the
table. I mean without a primary key assigned for a table, we
cannot add foreign key.
Once the primary key is found, then query to add is been
already given by the above posters.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
Why do you partition data?
What is sql profiler in oracle?
What are the events on which a database trigger can be based?
How to get each name only once from an employee table?
what are tables and fields? : Sql dba
How to use distinct and count in sql query? Explain
Is null operator in sql?
How do you declare a user-defined exception?
What are operators available in sql?
What is embedded sql what are its advantages?
Are stored procedures faster than queries?
How to create your own reports in sql developer?
What has stored procedures in sql and how we can use it?
How to display the current date in sql?
