This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
novo_motion_schema_editor [2021/02/03 23:35] dlm [NovoMotion Schema Editor - Drop Down Menus] |
novo_motion_schema_editor [2021/02/05 21:19] dlm |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | [[main_page|NovoMotion Outbound Menu]] | ||
====== NovoMotion Schema Editor ====== | ====== NovoMotion Schema Editor ====== | ||
Line 200: | Line 201: | ||
- | Note: The Generate SQL Script is used when one wants to generate script to create the SQL table (See the [[creating_a_sql_script|Creating a SQL Script]] | + | Note: The Generate SQL Script is used when one wants to generate script to create the SQL table (see [[creating_a_sql_script|Creating a SQL Script]]) to avoid the necessity of creating the SQL table by hand. This is often used multiple times during the development of new schema to perfect the information between U2 and SQL. |
- | The SQL script can be pasted into SQL Management Studio and executed. It will drop any existing SQL table of the name defined in the schema and re-create it with the columns defined in the schema. It does this for both the base SQL table and - if an @ACTION row exists - for the parallel SQL trigger table. | + | The SQL script can be pasted into SQL Management Studio and executed. It will drop any existing SQL table of the name defined in the schema and re-create it with the columns defined in the schema. It does this for both the base SQL table and - if an @ACTION row exists - for the parallel SQL trigger table. |
If a SQL table has already been established and the schema needs to change, the user has the following options: | If a SQL table has already been established and the schema needs to change, the user has the following options: | ||
- | - Generate the SQL script through the Schema Editor, copy it, paste it into SQL Management Studio, and execute the script. | + | - Generate the SQL script through the Schema Editor, copy it, paste it into SQL Management Studio, and execute the script. |
- Change, add, or delete the desired information in the schema via the Schema Editor, then make the same changes to the SQL table via SQL tools. | - Change, add, or delete the desired information in the schema via the Schema Editor, then make the same changes to the SQL table via SQL tools. | ||
Line 217: | Line 218: | ||
- | + | \\ | |
+ | [[main_page|NovoMotion Outbound |