Synapse Tables are designed to provide users the ability Synapse Tables are used to create tabular data that is web-accessible, sharable, and queryable data. Columns in tables have a user-specified, structured schema. Users You can define table Table columns to contain common primitive data types (text, numbers, and dates, etc.) or references to other Synapse objects (e.g., Files).Tables may , like Files and Folders.
Tables may be queried and edited through both the Synapse web UI as well as through our the Synapse programmatic clients. Unlike most NoSQL systems, the data in Synapse Tables is Synapse Tables is strongly consistent, not eventually consistent. This is an important design consideration for scientific data processing, as analysis on eventually-consistent data sources can limit the types of analysis performed, and may require special coding strategies to ensure reasonable accuracy.
...
To modify information in a column, first begin by adding a new column, then copy the data from the column you would like to change into the newly created column, make the changes in the new column, and delete the old one. In this example, we are chaning changing the Column Type of Header_1 into Boolean and setting the Default Value to true. This is also true if you are changing a Table Column Type from representing a single value to multiple values, such as needing to change a Column Type from String to StringList or similar.
...
Deleting the Whole Table
...