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
- 11768 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
How do you delete data from a table?
how to delete an existing column in a table? : Sql dba
What is meant by truncate in sql?
What are stuff and replace function?
Show how functions and procedures are called in a pl/sql block.
What is cursor in pl sql?
Why we use stored procedure instead of query?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
what is user defined functions? : Sql dba
What trigger means?
What is 19 null in sql?
What are the types of functions in sql?
What is the maximum database size for sql express?
How do you add a column to a table?
What is a trigger word?
