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 rownum?
What is field delimiter?
Explain the difference between drop and truncate commands in sql?
Is mariadb nosql?
What is case function?
What is a unique key and primary key and foreign key?
What is the use of stored procedures?
What steps server process has to take to execute an update statement?
What is pl sql architecture?
What is a primary key sql?
What is trigger with example?
Why do you partition data?
What is cold data?
What is scalar data type in pl sql?
What are the popular database management systems in the it industry?