usecase: Change column properties

public usecase: Change column properties
Author:
Project: Phase: 1.0; Status: Proposed; Version: 1.0; Complexity: 1
Dates: Created: 7.12.2005 1:07:08; Modified: 7.12.2005 1:25:06;
Flags: Active: false; IsRoot: false; IsLeaf: false;
Extension Points:
UUID: {BA18C69F-E395-4587-A4DB-C3CC4737DAA3}
 

Goto: Scenarios

See also: Program

Appears in: UC Table

Connections
 
Change column properties Scenarios
Scenario Type Detail
Add column Simple Test if this table hasn't column with this name.
Alter table SQL using ConvertSQL for table connection.

After this change, columns info for table is updated.
Modify type Simple For modify data type use ConvertColumnTypeTo.
Possible conversions are:
- Int -> Int
- Int -> Double
- Int -> String
- Double -> Double
- Double -> String
- String -> String

After this change, columns info for table is updated.
Remove column Simple Test if this table has column with this name.
Alter table SQL using ConvertSQL for table connection.

After this change, columns info for table is updated.