How to Modify a Database Column in Supportworks: Difference between revisions

From support-works
Jump to navigation Jump to search
(Created page with "{{Template:Basic Cover |title=How to Modify a Database Column in Supportworks|type=FAQ |htl=Y }} {{Template:Basic Status |status=Published |version=1.0 |authors=HTL QA |appli...")
 
No edit summary
Line 12: Line 12:


== How to Modify a Database Column in Supportworks ==
== 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.

Revision as of 14:20, 19 May 2015



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.