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
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 can you save or place your msg in a table?
What is file based approach?
How do you declare a variable in pl sql?
How can one get sql*loader to commit only at the end of the load file? : aql loader
Can a varchar be a primary key?
What is the maximum number of triggers, you can apply on a single table?
What programs use sql?
What is compute?
How to call a javascript function from pl sql?
what is cross join? : Sql dba
How do I truncate a sql log file?
Is there a way to automate sql execution from the command-line, batch job or shell script?
Is sql harder than python?
Is full outer join same as cross join?
What are the basic sql commands?