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
how to see the create table statement of an existing table? : Sql dba
how do you know if your mysql server is alive? : Sql dba
How can I tell if sql is running?
How can triggers be used for the table auditing?
Can we join more than 2 tables in sql?
What is before and after trigger?
Can we change the table name in sql?
What is raw datatype in sql?
Determine if oracle date is on a weekend?
How do I run a pl sql procedure in sql developer?
Explain the rollback statement?
What is pl/sql table? Why it is used?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
Is sql scripting language?
How is use pl and sql?