It somewhat depends on how you've set up your project as to whether you'll be able to see the script or not. There's nothing in the Deployment Manager UI, but you could certainly grab the nuget file from your feed and open it up to have a look using something like Nuget Explorer
However, if you're using Dynamic database packages then there probably won't be anything to see, because the script is generated on the fly during deployment. You can choose to validate the deployment either before or after the upgrade by setting some variables. Please see here
for details on deployment validation.