add batch
remove batch
split batch
comment selection
show hidden batches
hide batch
db<>fiddle
Db2
DuckDB
Firebird
MariaDB
MySQL
Oracle
Postgres
SQL Server
SQLite
TimescaleDB
YugabyteDB
11.1
11.5
12.1
1.4 LTS
3.0
4.0
5.0
10.2
10.3
10.4
10.5
10.6
10.7
10.8
10.9
10.11
11.4
11.8
12.3
5.5
5.6
5.7
8.0
8.4
9.7
11g Release 2
18c
21c
23ai
23c
26ai
8.4
9.3
9.4
9.5
9.6
10
11
12
13
14
15
16
17
18
19 beta 3
2012
2014
2016
2017
2017 (Linux)
2019
2019 (Linux)
2022
2025
3.8
3.16
3.27
3.39
3.45
3.53
2.11
2.14
2.28
2.6
2.8
2.18
2024.2 LTS
2025.2 LTS
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
Sakila
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
AdventureWorks
no sample DB
no sample DB
AdventureWorks
no sample DB
AdventureWorks
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
run
abort
markdown
clear
donate
feedback
about
By using db<>fiddle, you agree to license everything you submit by
Creative Commons CC0
.
CREATE TABLE PROJDEPT ( proj_dept_id NUMBER CONSTRAINT projdept_pk PRIMARY KEY );
CREATE TABLE PROJECT ( project_id NUMBER CONSTRAINT project_pk PRIMARY KEY, proj_dept_id NUMBER CONSTRAINT fk_project REFERENCES PROJDEPT ( proj_dept_id ) );
CREATE TABLE EMPLOYEE ( Employee_ID NUMBER CONSTRAINT employee_pk PRIMARY KEY, proj_dept_id NUMBER CONSTRAINT fk_EMPLOYEE REFERENCES PROJDEPT( proj_dept_id ) );
CREATE TABLE PROJECTTASK ( ID NUMBER CONSTRAINT projecttask_pk PRIMARY KEY, project_id NUMBER CONSTRAINT fk_PROJECTTASK REFERENCES PROJECT( project_id ), employee_id NUMBER CONSTRAINT fk_PROJECTTASK2 REFERENCES EMPLOYEE( employee_id ) );
ALTER TABLE PROJECTTASK DROP CONSTRAINT PROJECTTASK_pk DROP CONSTRAINT fk_PROJECTTASK DROP CONSTRAINT fk_PROJECTTASK2;
ALTER TABLE EMPLOYEE DROP CONSTRAINT EMPLOYEE_pk DROP CONSTRAINT fk_EMPLOYEE;
ALTER TABLE PROJECT DROP CONSTRAINT PROJECT_pk DROP CONSTRAINT fk_PROJECT;
ALTER TABLE PROJDEPT DROP CONSTRAINT PROJDEPT_pk;
ALTER TABLE PROJDEPT ADD CONSTRAINT PROJDEPT_pk PRIMARY KEY (Proj_Dept_ID);
ALTER TABLE EMPLOYEE ADD CONSTRAINT EMPLOYEE_pk PRIMARY KEY (Employee_ID);
ALTER TABLE EMPLOYEE ADD CONSTRAINT fk_EMPLOYEE FOREIGN KEY (Proj_Dept_ID) REFERENCES PROJDEPT(Proj_Dept_ID);
ALTER TABLE PROJECT ADD CONSTRAINT PROJECT_pk PRIMARY KEY (Project_ID);
ALTER TABLE PROJECT ADD CONSTRAINT fk_PROJECT FOREIGN KEY (Proj_Dept_ID) REFERENCES PROJDEPT(Proj_Dept_ID);
ALTER TABLE PROJECTTASK ADD CONSTRAINT PROJECTTASK_pk PRIMARY KEY (Project_ID, Employee_ID);
ALTER TABLE PROJECTTASK ADD CONSTRAINT fk_PROJECTTASK FOREIGN KEY (Project_ID) REFERENCES PROJECT(Project_ID);
ALTER TABLE PROJECTTASK ADD CONSTRAINT fk_PROJECTTASK2 FOREIGN KEY (Employee_ID) REFERENCES EMPLOYEE(Employee_ID);