Data Object editor

You can use the Data Object editor to create or alter data objects directly from the Data Source Explorer. You can run the CREATE and ALTER DDL scripts that are generated by the Data Object editor to deploy your changes to the database.
The Data Object editor consists of sections that are interrelated. Actions in the top two sections modify the DDL script in the bottom section.
Data Object Properties
The properties tabs in this section of the editor specify or modify properties for the data object. As you modify properties in this section, click Preview DDL in the DDL section of the editor and the DDL script is modified to reflect your changes. If you use the editor to create a new object, you can click Import Definition to initialize the properties tabs with the values from another data object of the same data object type. When the changes are complete, you can preview the generated DDL script in the DDL section of the editor, run the generated DDL script, and deploy your changes.
Impacted Objects
The objects in this section are potentially impacted by any changes to the object that you modify in the editor. Select an impacted object to include DROP and recreate actions on the object in the generated DDL script. In the recreate statements, impacted objects are not modified according to the changes you make to the root object, so you might need to open the DDL script in the SQL editor and make additional changes to the objects. For example, if a column is removed from a table in the Data Object editor, you must also manually remove it from the SELECT statement of any related views. By default, all impacted objects are selected and included in the DDL script. To view the properties of an impacted object, highlight the object in the tree and open the Properties view.
DDL
The generated DDL script is displayed in this section. You cannot type in the text field, however, if you want to make changes to the DDL script, you can open the script in the SQL editor, where you can make changes and save the script to an existing data project.

Feedback