I added a new custom field to an object with many existing records. It was a checkbox field and during creation I specified the default value to be "true". However, it looks like all the records have the new field unchecked. Is this expected behaviour? More importantly, is there a way to mass update the value of the new field, like:
UPDATE Input_Source__c
SET Hide_Province_Field__c = true
I have tried the developer console, but either my syntax is wrong or you can't run update queries through the console.