Friday 17 November 2023

Syntax for creating new column store table

Ex1:



 Create column Table Test_ColumnTB1 (

   Cust_ID INTEGER,
   Cust_NAME VARCHAR(10),
   PRIMARY KEY (Cust_ID)
);


ex 2

CREATE COLUMN Table XJRM63.Testfordatamasking ( "EMP_ID" varchar(10), "Emp_name" varchar (20), "Emp_salary" nvarchar (11)) ;

No comments:

Post a Comment