Create table using API

— // Drop the Table
execsql,c,DROP TABLE DMS_AUDIT
execsql,c,COMMIT

— // Create the Table
execsql,c,CREATE TABLE [dbo].[DMS_AUDIT]([r_object_id] nvarchar NOT NULL,[audited_obj_id] nvarchar NOT NULL,[time_stamp] nvarchar NULL,[user_name] nvarchar NOT NULL, [user_id] nvarchar NOT NULL, [chronicle_id] nvarchar NOT NULL, [object_name] nvarchar NULL, [object_type] nvarchar NOT NULL,[event_name] nvarchar NOT NULL,[event_source] nvarchar NOT NULL,[event_description] nvarchar NOT NULL) ON [PRIMARY]
execsql,c,COMMIT

–############TABLE my_attrib_definitions Population #####
— execsql,c,INSERT INTO DMS_AUDIT VALUES (‘2234567890123456’, ‘20151030’, ‘Suhas Das’, ”)

— alter table DMS_AUDIT alter column [time_stamp] nvarchar NULL;

Leave a Reply

Your email address will not be published. Required fields are marked *