#13 Changing table column property generates new table

[Anonymous]

When changing a table column property. An error is
generated and a temporary table is created with the
name tablename_temp.

Steps to reproduce:

1: Click on the new table icon on the left treeview control.
2: Give table name and in the top row check the Key
check box (create primary key on field).
3: Save table.
4: Click on the table icon on the form now showing in
the browser window.
5: Click the Insert button on the right of the only row
showing.
6: Give column name, type, etc. and click the Save
Table button.
7: Error appears.

If you follow steps 1 - 4 and on step 5 you enter 1 into
text box next to Add Columns and click the Add
Columns button, it appears to function properly.

It seems that the primary key is being changed from
PK_tablename to PK_tablename_temp and when a
subsequent change is made to the table it is trying to
recreate the index with the same name causing a PK_
[table] error because this database object already
exists. This is followed by a new table with the name of
what should have been the recreated index.

Technical Support
support@csmanagednetworks.com
CS Managed Networks - "When only the best will do!"

[Tony]

Logged In: YES
user_id=880438

This seems to only happen when creating a primary key. Also
can't delete a column that has a primary key on it.