Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 nagavenkata naveen (nagavenkatan1807)
igate global solutions

igate global solutions
IN
nagavenkatan1807 Member since 2015 15 posts
igate global solutions
Posted: Aug 17, 2015
Last activity: Aug 17, 2015
Posted: 17 Aug 2015 3:32 EDT
Last activity: 17 Aug 2015 4:38 EDT
Closed
Solved

What about data if i delete a exposed column from a table


For example, I have few columns and a BLOB in a table where I have deleted one exposed column from the table along with data(of course a column can be deleted only when data is cleared).

Now the data of the column deleted exists in BLOB column or it is lost completely.

Let me understand what exactly when we expose a column. Will a copy of the column exists in BLOB or not when exposed. If a copy exists will it get deleted when the exposed column deleted.

To see attachments, please log in.

Accepted Solution

Posted: 9 years ago
Posted: 17 Aug 2015 4:05 EDT
Rajiv Nistala (nistr) Senior Manager - Engineering
Pegasystems
IN

1) When a column is exposed, the data is present both in the BLOB and in the exposed column.

2) When a column is dropped from the table, the data is retained in the BLOB

To see attachments, please log in.
  • Deven Clingman Snehasis Panda Manmohan Jangid

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice