When you connect using OLE DB and change the name or width of a column in a Microsoft SQL Server 2000 database using Alter Table in the Database painter, the column is moved to the end of the table and all its data is lost. To prevent this from occurring, PowerBuilder does not allow you to alter a table's column name and column size. You can alter the table outside the painter using ISQL scripts or at runtime using PowerScript® functions. Note that SQL scripts to alter a column's name are available only on the SQL Server 2000 client. [CR 348581]
