How to create a table using constraints...
IF i change the PARENT KEY value ,then CHILD KEY
table will also to change in the another table...
plz reply ur answers @ mak2786@gmail.com
Arunkumar
- 3 Answers
- 7080 Views
- I also Faced
- E-Mail Answers
Answer Posted / alien
1>
2> CREATE TABLE employee (emp_no INTEGER NOT NULL
CONSTRAINT prim_empl PRIMARY KEY,
3> emp_fname CHAR(20) NOT NULL,
4> emp_lname CHAR(20) NOT NULL,
5> dept_no CHAR(4) NULL)
6>
7> CREATE TABLE project (project_no CHAR(4) NOT NULL
CONSTRAINT prim_pro PRIMARY KEY,
8> project_name CHAR(15) NOT NULL,
9> budget FLOAT NULL)
10>
11> CREATE TABLE works_on1
12> (emp_no INTEGER NOT NULL,
13> project_no CHAR(4) NOT NULL,
14> job CHAR (15) NULL,
15> enter_date DATETIME NULL,
16> CONSTRAINT prim_works1 PRIMARY KEY(emp_no,
project_no),
17> CONSTRAINT foreign1_works1 FOREIGN KEY
(emp_no) REFERENCES employee(emp_no) ON DELETE CASCADE)
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What is data types in sql?
What will you get by the cursor attribute sql%notfound?
Explain unique key in sql.
What are the types of index in sql?
Where not exists in sql?
Explain the uses of control file.
Is null operator in sql?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
Are stored procedures faster than queries?
Is it important to partition hard disk?
what is the functionality of the function htmlentities? : Sql dba
What is update query?
How do you explain an index?
What is fmtonly in sql?
What is the need of a partition key?
