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:36] 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: | ||
Line 217: | Line 218: | ||
- | + | \\ | |
+ | [[main_page|NovoMotion Outbound |