Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7682 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 a rank in sql?
Does sql require a server?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
What are the types of triggers in sql?
What is the difference between having clause and where clause?
Can we create table in function?
What are the sql aggregate functions?
What are the types of optimization?
what are the 'mysql' command line arguments? : Sql dba
What are character functions?
How do you declare a user-defined exception?
what is a control file ? : Sql dba
Which query operators in sql is used for pattern matching?
What is meant by user defined function?
What are the uses of merge?
