hello there,

an addition to the "drop and create" question:in newer SQLServer versions finally the CREATE OR ALTER syntax was introduced. I'm not sure if in SQL 2014, but I know about it in SQL 2016.
Still I totally agree with Ed Wagner, having all the security stuff as part of the code. When dealing with topics like "continious delivery" this may be an important factor.
(I'm not having it right now, but have to deal with this soon).