This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
novo_motion_schema_editor [2021/02/03 22:13] dlm [NovoMotion Schema Editor - U2 Options Tab - SA Map Example] |
novo_motion_schema_editor [2021/02/03 23:37] dlm [NovoMotion Schema Editor - Drop Down Menus] |
||
---|---|---|---|
Line 10: | Line 10: | ||
- | {{: | ||
+ | {{: | ||
Line 87: | Line 87: | ||
- | {{:novoschema2.jpg?400|}} | + | {{:file: |
Line 102: | Line 102: | ||
- | ==== NovoMotion Schema Editor - SQL Options tab - SA map example | + | ==== NovoMotion Schema Editor - SQL Options tab - SA Map Example |
- | + | {{: | |
- | {{file_novo_schema3.jpg}} | + | |
Line 128: | Line 127: | ||
- | ==== NovoMotion Schema Editor - Post Job Options | + | ==== NovoMotion Schema Editor - Post Job Options |
- | {{file_novo_schema4.jpg}} | + | {{: |
Line 152: | Line 151: | ||
- | The function contains the following drop down menus: | + | ==== NovoMotion Schema Editor - Drop Down Menus ==== |
- | * **File** | + | === File === |
+ | |||
Line 175: | Line 176: | ||
- | * **Edit** | + | === Edit === |
Line 185: | Line 187: | ||
- | * **Tools** | + | === Tools === |
Line 198: | Line 200: | ||
- | **Note:** The Generate SQL Script is used when one wants to generate script to create the SQL table (See the Creating a SQL script information) 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. | + | 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. | ||
- | **Additional Usage Notes: | + | 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. |
- | * **Help** | + | === Help === |