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
- 7856 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
How do I order by ascending in sql?
Is json a nosql?
How to write a query to show the details of a student from students table whose
What is primary key and foreign key?
How many types of sql are there?
define sql insert statement ? : Sql dba
What is the difference between pl and sql?
How to execute a stored procedure?
what is innodb? : Sql dba
What is a constraint? Tell me about its various levels.
What does inner join mean?
How to find 3rd highest salary of an employee from the employee table in sql?
What is plpgsql language?
What is the use of index in hive?
What is the purpose of using pl/sql?
