There are two ways to show the script display window, through double clicking a red or green highlighted script from the list in the results panel under the scales icon or by accessing the "Display Script" option from the right click menu (right clicking on a script in either database).
The display windows shows full greater detail than the results window. It shows the full script name including database and schema name. It also allows the user to see the script in entirety before taking action such as deleting in the source database or deploying to the destination database.
Script exists in the red database but not the green database:
Script exists in the green database but not the red database: