I am going to generate a script to move objects from my test to production SQL Servers. I right click on the database and go to task and select Generate Scripts. In the Script Options for Objects - in the Script Behavior option- there should be 3 options:
1. Drop statements
2. CREATE statements
3. Drop followed by CREATE statements.
All I get are the first 2 options but I really need the 3rd option. Why would this be missing? Thanks!