Jump to content
  • 0

Replace data table - start over with no data but preserve dependencies



I have a good app going with one main data table with lots of views and dependencies tied to it.  I want to change some field types in the table - from Text to Integer, etc.  But all the warning scare me about lost data if I proceed and "incompatible data will be lost."

To preserve all the dependencies will this work?

  1. COPY that original table and data (call it Table 1)  to "Table 1 Backup".   
  2. Copy Table 1 again and all it Table New
  3. Change field types in Table New, save it.  
  4. Delete original Table 1 and RENAME Table NEW to Table 1 (the original one  referenced in all the views and data pages).


Will that start me over with a new table with no data and preserve all the dependent reference to "Table 1" in the app?

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

If you remove a table all the pages based on it will be removed. If you want to change the datatype of a column you can export your data out in excel. Change the data type in Caspio. List all DataPages that you need to reselect and modify after changing data type. If the data in that column is removed, you need to import that excel sheet and replace with your current table.

I would recommend you to create a copy of your application and play with that first and see how the changes affect your table and DataPages

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...