Skip to Content (Press Enter)
2019-10-04 15-01-22
Dhiraj Manwani
37Views
3Comments
Solved
Delete all values in a column
Question

Hi All,

I want to remove all the values in a column of a database entity,

Can anyone give me the query.

I don't want to drop the column, i want to just remove values.


Thanks in advance :)

Dhiraj M

0
0
28 May 2020
Copy Link
2021-03-05 13-56-11
Ricardo Pereira
 
MVP
Solution

Hi,


You can do it in an SQL node (since it's a bulk operation, for performance questions, it's better) and is something like this:

UPDATE {Table Name} SET {Table Name}.[Column Name] = Null;

You need to understand the type of data in that column and adapt the "null".

You can use a dummy structure as output just to avoid the error.


Hope this can help.


Best regards,

Ricardo M Pereira

1
0
28 May 2020
Copy Link
2019-10-04 15-01-22
Dhiraj Manwani

Ricardo Pereira wrote:

Hi,


You can do it in an SQL node (since it's a bulk operation, for performance questions, it's better) and is something like this:

UPDATE {Table Name} SET {Table Name}.[Column Name] = Null;

You need to understand the type of data in that column and adapt the "null".

You can use a dummy structure as output just to avoid the error.


Hope this can help.


Best regards,

Ricardo M Pereira

Thanks Ricardo, it worked :)


0
0
28 May 2020
Copy Link
2021-03-05 13-56-11
Ricardo Pereira
 
MVP

Hi,


Glad to know. :)


Best regards,

Ricardo M Pereira

0
0
28 May 2020
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.