Alter Table

[Damanindahaus]

hi mates,

i need ur help again. it is about altering a table. i would develop it like this:

ALTER TABLE table_name ALTER COLUMN column_name SET PRO_SQL_WIDTH x(128)

some questions:
- is this anyway possible?
- if yes, is this possible to a table which is already filled with thousands of entries?
- are there any problems that can be caused of this statement?
- can the entries be destroyed through this statement?
any suggestions?

regards
Daman

 

[Damanindahaus]

btw, is alter table possible to progress 9.1d? or is this first supported from open edge versions?

 

[MaximMonin]

I think progress divides tables on types
Progress and SQL
If it is table created by SQL and has SQL type it is possible to alter it, if it has PROGRESS type, i am not sure it is possible at all.