Delete a field if the field is blank for all records

Here is the command to delete a field (column) from the database if all of the records are blank in that field.

! Get Field Name com_FieldName="myField" ! Count records that are not empty COUNT FOR !EMPTY(&com_FieldName) TO com_Count ! Create a Delete Column String if Count is 0 com_AlterString=IIF(com_Count=0,[ALTER TABLE (ALIAS()) DROP COLUMN &com_FieldName],[]) ! Run AlterString line &com_AlterString

*!* Get Field Name
com_FieldName="myField"

*!* Count records that are not empty
COUNT FOR !EMPTY(&com_FieldName) TO com_Count

*!* Create a Delete Column String if Count is 0
com_AlterString=IIF(com_Count=0,[ALTER TABLE (ALIAS()) DROP COLUMN &com_FieldName],[])

*!* Run AlterString line
&com_AlterString

« Back to Commands

New to the
Mailing
Industry?
More Info

Professional Services
More Info

I’m influenced and impressed by the AccuZIP support personnel you have. We had setup issues on Friday and I was jamming things through my mail department and wanted to be able to use AccuTrace THAT DAY. It was important for my client. As a result I phoned support and spoke to a wonderfully pleasant woman who was extremely knowledgeable, polite and helpful. Donna whom I believe lived in Georgia was the representative. She is a treasure.

T.R., San Luis Obispo, CA