© Soft Metrics Consulting, February 14, 2021
create column table "<Schema_name>"."ZZSTUDENT"( "ROLLNUMBER" NVARCHAR (10) not null,
"NAME" NVARCHAR (10) ,
"YEAR" NVARCHAR (4) );
create column table "SYSTEM"."ZZSTUDENT"( "ROLLNUMBER" NVARCHAR (10) not null,
"NAME" NVARCHAR (10) ,
"YEAR" NVARCHAR (4) );
CREATE COLUMN TABLE "<SCHEMA_NAME>"."ZZENROLL"( "CODE" NVARCHAR (10) NOT NULL,
"ROLLNUMBER" NVARCHAR (10) NOT NULL,
"YEAR" NVARCHAR (4) );
CREATE COLUMN TABLE "<SCHEMA_NAME>"."ZZCOURSE"( "CODE" NVARCHAR (10) NOT NULL,
"NAME" NVARCHAR (10));
CREATE TYPE "<SCHEMA_NAME>"."LT_OUT" AS TABLE ( "STUDENT_NAME" VARCHAR (10) NOT NULL,
"COURSE_CODE" VARCHAR (10),
"COURSE" VARCHAR (10));
Create using SQL Statement