Scribd
Upload
5 views1 page

SQL Table Creation for Test Data

The document contains SQL statements that create multiple tables with different names and fields to store test data. The tables are created with different constraints like primary keys, foreign keys, unique constraints and check constraints.

Uploaded by

Renju George
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
5 views1 page

SQL Table Creation for Test Data

The document contains SQL statements that create multiple tables with different names and fields to store test data. The tables are created with different constraints like primary keys, foreign keys, unique constraints and check constraints.

Uploaded by

Renju George
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

CREATE TABLE ALL_TEST1 (

TEST_CODE VARCHAR(10),
TST_TYPE CHAR(10));

CREATE TABLE Test_Tabl1(


TEST_ID int,
TEST_NAME VARCHAR(20),
TEST_CODE CHAR(10),
TEST_STATE CHAR(2),
TEST_SUBJ_CODE CHAR(4),
TEST_SUBJ_MARKS INT
);

TYPE 2

CREATE TABLE all_test2


(
TEST_CODE VARCHAR(10) PRIMARY KEY,
TEST_DOMAIN VARCHAR(20) NOT NULL,
TEST_TYPE CHAR(10) NOT NULL
);

CREATE TABLE TEST_TABLE2


(
TEST_ID INT PRIMARY KEY,
TEST_NAME VARCHAR(20) NOT NULL,
TEST_CODE VARCHAR(10) REFERENCES ALL_TEST2(TEST_CODE),
TEST_STATE CHAR(2),
TEST_SUBJ CHAR(4) UNIQUE,
TEST_SUBJ_MARK INT CHECK(TEST_SUBJ_MARK<100)
);

TYPE 3

CREATE TABLE ALL_TEST3 (


TEST_CODE VARCHAR(10) CONSTRAINT TC_PK PRIMARY KEY,
TEST_DOMAIN VARCHAR(20) CONSTRAINT TD_NN NOT NULL,
TEST_TYPE CHAR(10) CONSTRAINT TT_NN NOT NULL);

CREATE TABLE TEST_TBL3 (


TEST_ID INT CONSTRAINT TTD_PK PRIMARY KEY,
TEST_NAME VARCHAR(20) CONSTRAINT TNM_NN NOT NULL,
TEST_CODE VARCHAR(10) CONSTRAINT TC_REF REFERENCES ALL_TEST3(TEST_CODE),
TEST_STATE CHAR(2),
TEST_SUBJ_CODE CHAR(4) CONSTRAINT TSCD_UNQ UNIQUE,
TEST_SUBJ_MARK INT CONSTRAINT TMRK_CHQ CHECK(TEST_SUBJ_MARK<100))

TYPE 4

CREATE TABLE ALL_TEST4 AS SELECT * FROM ALL_TEST1;

You might also like