How to add Foreign key in a table after the creation of the
table?
- 5 Answers
- 10755 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 function and trigger?
What is memory optimized?
What is Collation Sensitivity ? What are the various type ?
Is time a data type in sql?
What is union?
What is sorting in sql?
What does := mean in pl sql?
How to create an array in pl/sql?
What is indexing in sql and its types?
What is the difference between sql and t sql?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Can delete statement be rollbacked?
What is left inner join in sql?
When is a declare statement required?
Write a unique difference between a function and a stored procedure.
