All Posts

Create table using API

S

By Suhas Das

Author

3 views

-- // 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;

0 Comments

Leave a Comment

Your email will not be published. Comments are subject to moderation.