Sample Data Table Global Customization Script

The following example shows how to use one statement to rename all occurrences of the column name ts to time_stamp in the item_name column of the DATAITEMS client control table for the DMSII database whose data source name is CMDB. Create only one of these scripts for each data source.

File name: script.user_datatables.cmdb

update DATAITEMS set item_name = 'time_stamp'
where item_name = 'ts'