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
Explain the uses of a database trigger?
What is the usage of the distinct keyword?
What is a primary key sql?
Who is the owner of mysql database?
What is the maximum number of columns in sql table?
What is data abstraction in sql?
What is set serveroutput on in pl sql?
how would you enter characters as hex numbers? : Sql dba
Enlist the characteristics of pl/sql?
What are the key differences between SQL and PL SQL?
how many sql dml commands are supported by 'mysql'? : Sql dba
what are the different index configurations a table can have? : Sql dba
What are sql commands?
What is sql stand for?
List the different type of joins?