Interested to Buy Any Domain ? << Click Here >> for more details...
How do I create a table MANAGER (EMP-NO, MANAGER) where
MANAGER is a foreign key which references to EMP-NO in the
same table? Give the exact DDL.
- 3 Answers
- 6975 Views
- I also Faced
- E-Mail Answers
Answer Posted / s
CREATE TABLE QUALIFIER.TABLE
(EMP-N0 CHAR(6) NOT NULL,
MANAGER CHAR(6) NOT NULL)
IN TABLESPACE;
ALTER TABLE QUALIFIER.TABLE
FOREIGN KEY FKM (MANAGER) REFERENCES QUALIFIER.TABLE
ON DELETE CASCADE;
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Why do chiropractors use drop table?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
Explain about rct in db2?
When the like statement is used?
What is the default page size of buffer pools?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is db2 purescale?
What is a dbrm in db2?
What are the different types of base tables?
what is diffrence b/w file-aid tool and file-aid utility???
How do I delete a table in database?
Why do we bind in db2?
Explain dclgen.
What is a storage group (stogroup)?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
