I have multiple SQL scripts that need to be executed during deployment. I've packaged them with my app in the "sql-scripts" folder. In my case the order in which they are executing is important.
I understand that the entire file path is used and then scripts are executed in alpabetical order based on that.

My question is: Can I number my scripts by having the script names start with a number and when will those scripts be executed relative to scripts that only have non-numeric alphabet characters in their name / path?

For example in what order will scripts be executed if I have this structure:

sql-scripts (folder):
            -> refresh_tableau_report (folder):
                                  -> vw_stockupdate_history.sql
                                  -> vw_tableau_subsets.sql
            -> 01-grant_permission_external_readonly.sql