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 do backup entire database? : Transact sql
What is trigger in sql?
How many databases can sql express handle?
How can you fetch first 5 characters of the string?
Is sql pronounced sequel or sql?
Explain foreign key in sql?
How to avoid duplicate records in a query?
Is the primary key an index?
How do I view a table in sql?
How do I kill a query in postgresql?
Can we use pl sql in sql server?
Explain normalization and what are the advantages of it?
What is data manipulation language?
What is the difference between Union and Union all. Which is faster.
Why do we create stored procedures & functions in pl/sql and how are they different?