|
INTERVIEW QUESTIONS
DATABASE
FIREBIRD
DETAILS
Question: What is command for supporting foreign key in Firebird?
Answer: Lets do it by example:
create table Master_A( mst_1 integer not null primary key, mst_2 varchar(10));
create table slave_of_a(slv_1 integer not null, primary key, mst_1 integer);
alter table slave_of_a add constraint FK_2_MST foreign key (mst_1) references Master_A(mst_1);
Is the same command that sql92 supports.
alter table table_name add constraint constraint_name foreign key (field1,field2,...) references master_table(field1,field2...,);
|
|
|
Category |
Firebird Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 7691 users |
Added on |
4/3/2013 |
Views |
68631 |
Rate it! |
|
|
Question:
What is command for supporting foreign key in Firebird?
Answer:
Lets do it by example:
create table Master_A( mst_1 integer not null primary key, mst_2 varchar(10));
create table slave_of_a(slv_1 integer not null, primary key, mst_1 integer);
alter table slave_of_a add constraint FK_2_MST foreign key (mst_1) references Master_A(mst_1);
Is the same command that sql92 supports.
alter table table_name add constraint constraint_name foreign key (field1,field2,...) references master_table(field1,field2...,); Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
What is the maximum number of rows in a table in Firebird?
|
View Answer
|
|
What are the vital features of Firebird that makes it powerful database?
|
View Answer
|
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View All Firebird Interview Questions & Answers - Exam Mode /
Learning Mode
|