You work in the Data Source Explorer to create and alter data objects, manage privileges, and modify data. In a typical development scenario, you perform these types of tasks on test databases.
First, create a new table using the Data Object editor.
The script is run on the target database and the results, including any errors, are displayed in the SQL Results view. The new table is displayed in the Data Source Explorer under the schema in which you created it.
Next, modify another table. You use the Data Object editor to complete this task. However, first you will analyze the impact of your changes.
Results are displayed in the Model Report view. You can navigate to an impacted object in the Data Source Explorer by double-clicking it in the Model Report view. Use this feature to understand the impact of changes to a data object before you commit them.
This screen capture shows an example of an impact analysis report. Your report will look different depending on whether other objects have been created that have dependencies on the EMPLOYEE table.