How to Modify a Database Column in Supportworks

From support-works
Revision as of 14:20, 19 May 2015 by Deenc (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search



Status: Published
Version: 1.0
Authors: HTL QA
Applies to: Supportworks Version 7.0 onwards

How to Modify a Database Column in Supportworks

This document details how to modify a Database Column using the Supportworks Database schema Editor. The example below changes the type of the Opencall.AssignCount column from an Int to a VarChar.

1. Export schema from physical database

Run Supportworks database Schema Editor and from the Database menu select “Export Specification from physical database…” or click the icon. The following screen will appear.