Interested to Buy Any Domain ? << Click Here >> for more details...
How to add Foreign key in a table after the creation of the
table?
- 5 Answers
- 11938 Views
- Satyam, I also Faced
- E-Mail Answers
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 difference between group by and partition by?
Explain normalization and what are the advantages of it?
what is 'mysqladmin' in mysql? : Sql dba
What are the datatypes available in pl/sql ?
How can we optimize a sql query?
Can we use commit inside a trigger?
What's the procedure?
Define tables and fields in a database
does sql support programming? : Sql dba
What is difference between my sql and sql?
Difference between table function and pipelined function?
How run sql*plus commands that are stored in a local file?
which operator is used in query for pattern matching? : Sql dba
What is secondary key?
What are properties of the transaction?
