<p>wrt <a class="issue-link js-issue-link" data-error-text="Failed to load issue title" data-id="158200708" data-permission-text="Issue title is private" data-url="https://github.com/dbsrgits/sql-translator/issues/82" data-hovercard-type="issue" data-hovercard-url="/dbsrgits/sql-translator/issues/82/hovercard" href="https://github.com/dbsrgits/sql-translator/issues/82">#82</a>.  The procedures need to be added first, before the tables. I have a situation where a procedure is used for the default of a column and the deploy fails because it is not defined.<br>
Oddly you can define procedures that refer to tables and columns that don't yet exist. So doing it first 'just works'.</p>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">&mdash;<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/dbsrgits/sql-translator/issues/82#issuecomment-469775745">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AASeAvy0F8ZztN-LBrimVQZhgUMu2_-Iks5vTqpLgaJpZM4Isz-E">mute the thread</a>.<img src="https://github.com/notifications/beacon/AASeAlX-03jDVcsCR8tVZ4HafScOgz46ks5vTqpLgaJpZM4Isz-E.gif" height="1" width="1" alt="" /></p>
<script type="application/json" data-scope="inboxmarkup">{"api_version":"1.0","publisher":{"api_key":"05dde50f1d1a384dd78767c55493e4bb","name":"GitHub"},"entity":{"external_key":"github/dbsrgits/sql-translator","title":"dbsrgits/sql-translator","subtitle":"GitHub repository","main_image_url":"https://github.githubassets.com/images/email/message_cards/header.png","avatar_image_url":"https://github.githubassets.com/images/email/message_cards/avatar.png","action":{"name":"Open in GitHub","url":"https://github.com/dbsrgits/sql-translator"}},"updates":{"snippets":[{"icon":"PERSON","message":"@yewtc in #82: wrt #82.  The procedures need to be added first, before the tables. I have a situation where a procedure is used for the default of a column and the deploy fails because it is not defined.\r\nOddly you can define procedures that refer to tables and columns that don't yet exist. So doing it first 'just works'."}],"action":{"name":"View Issue","url":"https://github.com/dbsrgits/sql-translator/issues/82#issuecomment-469775745"}}}</script>
<script type="application/ld+json">[
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"potentialAction": {
"@type": "ViewAction",
"target": "https://github.com/dbsrgits/sql-translator/issues/82#issuecomment-469775745",
"url": "https://github.com/dbsrgits/sql-translator/issues/82#issuecomment-469775745",
"name": "View Issue"
},
"description": "View this Issue on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>