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
What is trigger in sql?
Is sql between inclusive?
How can you tell the difference between an index and a view?
What are different joins used in sql?
What is normalisation and its types?
What is materialized view in sql?
Is sql port 1433 encrypted?
Is ms sql is free?
What are the different types of a subquery?
How can you save or place your msg in a table?
What do you think about pl/sql?
What are predefined functions in sql?
Explain the difference between triggers and constraints?
What are the two types of exceptions in pl/sql?
What are the different ddl commands in sql?