{"id":15737,"date":"2022-04-05T15:38:12","date_gmt":"2022-04-05T19:38:12","guid":{"rendered":"https:\/\/www.iri.com\/blog\/?p=15737"},"modified":"2022-06-28T18:54:52","modified_gmt":"2022-06-28T22:54:52","slug":"create-new-tables-in-iri-workbench","status":"publish","type":"post","link":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/","title":{"rendered":"Creating New Tables in IRI Workbench"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">This article demonstrates how to use <\/span><a href=\"http:\/\/www.iri.com\/products\/workbench\"><span style=\"font-weight: 400;\">IRI Workbench<\/span><\/a><span style=\"font-weight: 400;\"> to facilitate the creation of new relational database tables for everyday database administrator type jobs, and of course jobs you would perform in other IRI products, such as:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><a href=\"https:\/\/www.iri.com\/products\/nextform\"><span style=\"font-weight: 400;\">IRI NextForm<\/span><\/a><span style=\"font-weight: 400;\"> to migrate table data in one database schema to another<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><a href=\"https:\/\/www.iri.com\/products\/fieldshield\"><span style=\"font-weight: 400;\">IRI FieldShield<\/span><\/a><span style=\"font-weight: 400;\"> to read flat-file or table data, mask it, and write it into new tables<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><a href=\"https:\/\/www.iri.com\/products\/rowgen\"><span style=\"font-weight: 400;\">IRI RowGen<\/span><\/a><span style=\"font-weight: 400;\"> to synthesize data from scratch into empty tables based on DDL info<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><a href=\"https:\/\/www.iri.com\/products\/voracity\"><span style=\"font-weight: 400;\">IRI Voracity<\/span><\/a><span style=\"font-weight: 400;\"> to extract, transform, and load data from existing sources to new targets<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Thanks to the enhanced Data Tools Platform (DTP) interface, IRI Workbench users can easily create and use Structured Query Language (SQL)<\/span> <span style=\"font-weight: 400;\">to build tables and <\/span><a href=\"https:\/\/www.iri.com\/blog\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/\"><span style=\"font-weight: 400;\">run SQL jobs<\/span><\/a><span style=\"font-weight: 400;\">. SQL is a standard language for interfacing with a database. SQL was initially developed by IBM\u00ae.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Data Definition Language (DDL) is a subset<\/span><span style=\"font-weight: 400;\"> of SQL, and is used to create and alter the structure and metadata of objects in the database.<\/span> <span style=\"font-weight: 400;\">These database objects include schemas, tables, views, indexes, and more. Commonly used DDL commands are Create, Alter, and Drop.<br \/>\n<\/span><\/p>\n<h6><b>IRI Workbench<\/b><b><br \/>\n<\/b><\/h6>\n<p><span style=\"font-weight: 400;\"><a href=\"http:\/\/www.iri.com\/products\/workbench\">IRI Workbench\u2122<\/a> is the graphical user interface (GUI) for all IRI products, and more. Among many other things, IRI Workbench can connect to most databases. There are wizards and editors that can<\/span><span style=\"font-weight: 400;\"> generate, edit, and run SQL scripts, including\u00a0 DDL. Among the DDL statements which can be generated are those to create, alter, and drop tables, keys, indexes and constraints.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">For these wizards to work with your tables, you will need to connect your databases to IRI Workbench using both JDBC and ODBC connections. Once connected through JDBC drivers, you can view schemas, tables and work with them with IRI products. Find how-to-connect articles for various databases <\/span><a href=\"https:\/\/www.iri.com\/services\/training\/courseware#install\"><span style=\"font-weight: 400;\">here<\/span><\/a><span style=\"font-weight: 400;\">.\u00a0\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">To create one or more tables, you will need to <\/span><a href=\"https:\/\/www.iri.com\/blog\/data-transformation2\/creating-executing-sql-statements-in-iri-workbench\/\"><span style=\"font-weight: 400;\">execute<\/span><\/a><span style=\"font-weight: 400;\"> the applicable CREATE TABLE (as well as available ALTER TABLE) statements in IRI Workbench. These DDL statements can come from three places:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">A .SQL file you already have containing the statements<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Tables in schema connected in IRI Workbench, as seen in the Data Source Explorer<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Automatic conversion (in Workbench) of SortCL \/FIELD statements<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">The next two sections of this article cover methods 2 and 3 above.<\/span><\/p>\n<h6><b>Create New Tables from Workbench-Connected, Existing Table DDL\u00a0<\/b><\/h6>\n<p><span style=\"font-weight: 400;\">Thanks to the Data Tools Platform (DTP) plugin for Eclipse and IRI enhancements thereto, IRI Workbench users can do a variety of data discovery, administration, and IRI processing of multiple databases connected through JDBC.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Workbench users can start with data discovery; they can <\/span><a href=\"https:\/\/www.iri.com\/products\/workbench\/discover-data\"><span style=\"font-weight: 400;\">profile, search, and diagram<\/span><\/a><span style=\"font-weight: 400;\"> any connected schema. The screenshot below shows the E-R Diagram of the tables in Schema name <\/span><b>Person <\/b><span style=\"font-weight: 400;\">in SQL Server.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">To create this view, select the tables in the DTP Data Source Explorer (DSE) view, right-click on <\/span><i><span style=\"font-weight: 400;\">IRI, <\/span><\/i><span style=\"font-weight: 400;\">and click <\/span><i><span style=\"font-weight: 400;\">New ERD<\/span><\/i><span style=\"font-weight: 400;\"> to open the E-R diagram displaying the tables\u2019 structure and relationships:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-15741 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2022\/04\/E-R-diagram-structure-relationships-300x196.png\" alt=\"\" width=\"661\" height=\"432\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/E-R-diagram-structure-relationships-300x196.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/E-R-diagram-structure-relationships-1024x669.png 1024w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/E-R-diagram-structure-relationships-768x502.png 768w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/E-R-diagram-structure-relationships-1536x1004.png 1536w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/E-R-diagram-structure-relationships.png 1577w\" sizes=\"(max-width: 661px) 100vw, 661px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">You can also use the connection to export and re-use the DDL information of the tables to facilitate the creation of new tables with the same or modified CREATE and ALTER table attributes.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">To do that, double click on a JDBC-connected database instance, and then the schema and tables you want to use. Specifically:\u00a0<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Right-click on the DB name and schema (e.g., <\/span><i><span style=\"font-weight: 400;\">SQL Server<\/span><\/i><span style=\"font-weight: 400;\"> -&gt; <\/span><i><span style=\"font-weight: 400;\">Person <\/span><\/i><span style=\"font-weight: 400;\">schema)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Select the tables to recreate<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Right-click and select <\/span><i><span style=\"font-weight: 400;\">Generate DDL \u2026<\/span><\/i><span style=\"font-weight: 400;\"> (Figure 1)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">The Generate DDL dialog will open (Figure 2)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Select Next and click to check the desired attributes to include in the new DDL script<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Click Next (so you can Save the Script), and Next<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">A summary page shows the CREATE TABLE and constraint statements (Figure 3).<\/span><\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-15742 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2022\/04\/Generate-create-table-DDL-300x180.png\" alt=\"\" width=\"553\" height=\"332\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Generate-create-table-DDL-300x180.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Generate-create-table-DDL.png 675w\" sizes=\"(max-width: 553px) 100vw, 553px\" \/><\/p>\n<p style=\"text-align: center;\"><b><i>Figure 1:<\/i><\/b><i><span style=\"font-weight: 400;\"> Generate CREATE TABLE DDL using the wizard built-into the IRI Workbench Data Source Explorer. Select the existing tables you want to recreate, right-click, and choose Generate DDL \u2026<br \/>\n<\/span><\/i><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-15744 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2022\/04\/Model-object-DDL-300x156.png\" alt=\"\" width=\"527\" height=\"274\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Model-object-DDL-300x156.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Model-object-DDL.png 512w\" sizes=\"(max-width: 527px) 100vw, 527px\" \/><\/p>\n<p style=\"text-align: center;\"><b><i>Figure 2: <\/i><\/b><i><span style=\"font-weight: 400;\">Select model objects to include in the DDL script<\/span><\/i><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-15745 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2022\/04\/save-run-DDL-209x300.png\" alt=\"\" width=\"500\" height=\"717\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/save-run-DDL-209x300.png 209w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/save-run-DDL.png 517w\" sizes=\"(max-width: 500px) 100vw, 500px\" \/><\/p>\n<p style=\"text-align: center;\"><b><i>Figure 3: <\/i><\/b><i><span style=\"font-weight: 400;\">After reviewing the script, select Next to Save (and eventually run) \u201cScript.SQL\u201d.<\/span><\/i><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-15747 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2022\/04\/Workbench-SQL-Scrapbook-300x228.png\" alt=\"\" width=\"660\" height=\"502\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Workbench-SQL-Scrapbook-300x228.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Workbench-SQL-Scrapbook-1024x779.png 1024w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Workbench-SQL-Scrapbook-768x584.png 768w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Workbench-SQL-Scrapbook.png 1198w\" sizes=\"(max-width: 660px) 100vw, 660px\" \/><\/p>\n<p style=\"text-align: center;\"><b><i>Figure 4:<\/i><\/b><i><span style=\"font-weight: 400;\"> Once saved, specifications open in the Workbench \u201cSQL Scrapbook\u201d (editor) above.<\/span><\/i><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">To use these commands to build new table\/s from the existing DDL, I also need a new schema ready to receive those tables. To do that,<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">In the SQL Scrapbook editing window (where the new Script.sql is open), modify the Schema name, and save the .SQL file (as shown below).<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Run in the new .SQL file to create the tables for the \u201cSales\u201d Schema in SQL Server\u00a0<\/span><\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-15750 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2022\/04\/Find-replace-person-sales-300x228.png\" alt=\"\" width=\"611\" height=\"464\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Find-replace-person-sales-300x228.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Find-replace-person-sales-768x583.png 768w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Find-replace-person-sales.png 907w\" sizes=\"(max-width: 611px) 100vw, 611px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">As shown above, I used the Find\/Replace wizard to modify the scripts. Then after running the .SQL statements, all my tables from the \u201cPerson\u201d schema are now also in the \u201cSales\u201d schema:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-15752 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2022\/04\/Data-source-explorer-236x300.png\" alt=\"\" width=\"398\" height=\"506\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Data-source-explorer-236x300.png 236w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Data-source-explorer.png 308w\" sizes=\"(max-width: 398px) 100vw, 398px\" \/><\/p>\n<h6><\/h6>\n<h6><b>Generate CREATE TABLE DDL from SortCL \/FIELD Statements<\/b><\/h6>\n<p><span style=\"font-weight: 400;\">It is also possible to automatically generate CREATE TABLE statements in IRI Workbench from the \/FIELD (column) layouts of source or target files or tables defined in the <\/span><a href=\"https:\/\/www.iri.com\/products\/cosort\/sortcl-metadata\"><span style=\"font-weight: 400;\">SortCL job scripts or DDF files<\/span><\/a><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">To generate DDL from IRI metadata:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Open an existing .SCL or .DDF file open for view\/edit in the Workbench editor<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Right-click inside the view. Select<\/span><i><span style=\"font-weight: 400;\"> IRI -&gt; Export -&gt; Export Fields to DDL\u2026<\/span><\/i><span style=\"font-weight: 400;\"> (Figure 1)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">In Section Selection, the screen chooses the relevant phase in the script (INFILE, INREC, or OUTFILE) to pull the \/FIELD attribute from (Figure 2)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Select OK to open the SQL configuration screen (Figure 3)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Change the table name and file name and select Next<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Follow the remaining steps captioned in Figures 4-7 below to create new tables.<\/span><\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-15754 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2022\/04\/Export-Fields-to-DDL-300x162.png\" alt=\"\" width=\"670\" height=\"362\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Export-Fields-to-DDL-300x162.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Export-Fields-to-DDL-1024x555.png 1024w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Export-Fields-to-DDL-768x416.png 768w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Export-Fields-to-DDL-1536x832.png 1536w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Export-Fields-to-DDL.png 1887w\" sizes=\"(max-width: 670px) 100vw, 670px\" \/><\/p>\n<p style=\"text-align: center;\"><b><i>Figure 1:<\/i><\/b><i><span style=\"font-weight: 400;\"> From the Context Menu Select IRI -&gt; Export -&gt; Export Fields to DDL.<\/span><\/i><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-15755 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2022\/04\/section-selection-convert-into-DDL-300x184.png\" alt=\"\" width=\"446\" height=\"274\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/section-selection-convert-into-DDL-300x184.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/section-selection-convert-into-DDL.png 394w\" sizes=\"(max-width: 446px) 100vw, 446px\" \/><\/p>\n<p style=\"text-align: center;\"><b><i>Figure 2:<\/i><\/b><i><span style=\"font-weight: 400;\"> Choose the section of the script with the \/FIELDs you want to convert into DDL.<\/span><\/i><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-15756 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2022\/04\/Name-SQL-file-300x171.png\" alt=\"\" width=\"536\" height=\"305\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Name-SQL-file-300x171.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Name-SQL-file.png 684w\" sizes=\"(max-width: 536px) 100vw, 536px\" \/><\/p>\n<p style=\"text-align: center;\"><b><i>Figure 3: <\/i><\/b><i><span style=\"font-weight: 400;\">Name (or rename) the .SQL file, table name, and schema name. Click Next.<\/span><\/i><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-15757 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2022\/04\/Specify-field-widths-300x177.png\" alt=\"\" width=\"552\" height=\"326\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Specify-field-widths-300x177.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Specify-field-widths.png 684w\" sizes=\"(max-width: 552px) 100vw, 552px\" \/><\/p>\n<p style=\"text-align: center;\"><b><i>Figure 4: <\/i><\/b><i><span style=\"font-weight: 400;\">Specify or modify specific field widths for the target columns. Click Next.<\/span><\/i><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-15759 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2022\/04\/Primary-Key-Unique-Constraints-Index-260x300.png\" alt=\"\" width=\"551\" height=\"636\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Primary-Key-Unique-Constraints-Index-260x300.png 260w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Primary-Key-Unique-Constraints-Index.png 683w\" sizes=\"(max-width: 551px) 100vw, 551px\" \/><\/p>\n<p style=\"text-align: center;\"><b><i>Figure 5: <\/i><\/b><i><span style=\"font-weight: 400;\">Select the Primary Key, Unique Constraints, and Indexes. Click to check which (different!) field name to assign in each case. Then click Next.<\/span><\/i><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-15760 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2022\/04\/Review-the-summary-table-data-260x300.png\" alt=\"\" width=\"551\" height=\"636\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Review-the-summary-table-data-260x300.png 260w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Review-the-summary-table-data.png 687w\" sizes=\"(max-width: 551px) 100vw, 551px\" \/><\/p>\n<p style=\"text-align: center;\"><b><i>Figure 6: <\/i><\/b><i><span style=\"font-weight: 400;\">Review the summary of table data types and constraints. Click Finish.<\/span><\/i><\/p>\n<p><span style=\"font-weight: 400;\">Once you are done with this wizard, the SQL Scrapbook editor opens. For the SQL file you are creating, you should specify the applicable database connection profile and confirm its: 1) driver type, 2) connection name, and 3) database instance.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Once you have the appropriate connections, you can highlight the desired section of the DDL code, right-click, and select <\/span><i><span style=\"font-weight: 400;\">Execute All \u2026, <\/span><\/i><span style=\"font-weight: 400;\">as shown below:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-15761 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2022\/04\/Running-the-FIELD-derived-DDL-300x241.png\" alt=\"\" width=\"665\" height=\"534\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Running-the-FIELD-derived-DDL-300x241.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Running-the-FIELD-derived-DDL-1024x822.png 1024w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Running-the-FIELD-derived-DDL-768x617.png 768w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Running-the-FIELD-derived-DDL.png 1187w\" sizes=\"(max-width: 665px) 100vw, 665px\" \/><\/p>\n<p style=\"text-align: center;\"><b><i>Figure 7: <\/i><\/b><i><span style=\"font-weight: 400;\">Running the \/FIELD-derived DDL to create one or more new tables in Oracle.<\/span><\/i><\/p>\n<h6><b>Summary<\/b><\/h6>\n<p><span style=\"font-weight: 400;\">IRI Workbench provides the ability to easily interact with and modify any connected relational database through the generation, manipulation, and execution of DDL statements. This article demonstrated two ways to create DDL and tables in IRI Workbench for a variety of purposes. If you have any questions or need assistance, please contact <\/span><a href=\"mailto:support@iri.com\"><span style=\"font-weight: 400;\">support@iri.com<\/span><\/a><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This article demonstrates how to use IRI Workbench to facilitate the creation of new relational database tables for everyday database administrator type jobs, and of course jobs you would perform in other IRI products, such as: IRI NextForm to migrate table data in one database schema to another IRI FieldShield to read flat-file or table<\/p>\n<div><a class=\"btn-filled btn\" href=\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/\" title=\"Creating New Tables in IRI Workbench\">Read More<\/a><\/div>\n","protected":false},"author":53,"featured_media":15744,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[31,91,3],"tags":[1679,1677,1678,1675,1674,77,659,850,1676,1680,24],"class_list":["post-15737","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-migration","category-iri-workbench","category-vldb-operations","tag-add-schema","tag-alter-table","tag-create-table","tag-create-tables","tag-data-definition-language","tag-data-migration-2","tag-ddl","tag-iri-workbench","tag-new-database-tables","tag-schema-create","tag-vldb"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Creating New Tables in IRI Workbench - IRI<\/title>\n<meta name=\"description\" content=\"This article demonstrates two ways to create DDL and tables in IRI Workbench for a variety of purposes. Including how to use IRI Workbench to facilitate the creation of new relational database tables for everyday database administrator type jobs, and of course jobs, you would perform in other IRI products.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating New Tables in IRI Workbench - IRI\" \/>\n<meta property=\"og:description\" content=\"This article demonstrates two ways to create DDL and tables in IRI Workbench for a variety of purposes. Including how to use IRI Workbench to facilitate the creation of new relational database tables for everyday database administrator type jobs, and of course jobs, you would perform in other IRI products.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-05T19:38:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-28T22:54:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Model-object-DDL.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"266\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Chaitali Mitra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Chaitali Mitra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/\"},\"author\":{\"name\":\"Chaitali Mitra\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/9bae14a309616863b027c2d56f532caf\"},\"headline\":\"Creating New Tables in IRI Workbench\",\"datePublished\":\"2022-04-05T19:38:12+00:00\",\"dateModified\":\"2022-06-28T22:54:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/\"},\"wordCount\":1139,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Model-object-DDL.png\",\"keywords\":[\"add schema\",\"alter table\",\"create table\",\"create tables\",\"Data Definition Language\",\"data migration\",\"DDL\",\"IRI Workbench\",\"new database tables\",\"schema create\",\"VLDB\"],\"articleSection\":[\"Data Migration\",\"IRI Workbench\",\"VLDB\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/\",\"url\":\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/\",\"name\":\"Creating New Tables in IRI Workbench - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Model-object-DDL.png\",\"datePublished\":\"2022-04-05T19:38:12+00:00\",\"dateModified\":\"2022-06-28T22:54:52+00:00\",\"description\":\"This article demonstrates two ways to create DDL and tables in IRI Workbench for a variety of purposes. Including how to use IRI Workbench to facilitate the creation of new relational database tables for everyday database administrator type jobs, and of course jobs, you would perform in other IRI products.\",\"breadcrumb\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/#primaryimage\",\"url\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Model-object-DDL.png\",\"contentUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Model-object-DDL.png\",\"width\":512,\"height\":266},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/beta.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Creating New Tables in IRI Workbench\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#website\",\"url\":\"https:\/\/beta.iri.com\/blog\/\",\"name\":\"IRI\",\"description\":\"Total Data Management Blog\",\"publisher\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/beta.iri.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\",\"name\":\"IRI\",\"url\":\"https:\/\/beta.iri.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"contentUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"width\":750,\"height\":206,\"caption\":\"IRI\"},\"image\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/9bae14a309616863b027c2d56f532caf\",\"name\":\"Chaitali Mitra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/95a11f3d0b709c00df3262bab0152f3a?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/95a11f3d0b709c00df3262bab0152f3a?s=96&d=blank&r=g\",\"caption\":\"Chaitali Mitra\"},\"sameAs\":[\"http:\/\/www.iri.com\"],\"url\":\"https:\/\/beta.iri.com\/blog\/author\/chaitalim\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Creating New Tables in IRI Workbench - IRI","description":"This article demonstrates two ways to create DDL and tables in IRI Workbench for a variety of purposes. Including how to use IRI Workbench to facilitate the creation of new relational database tables for everyday database administrator type jobs, and of course jobs, you would perform in other IRI products.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/","og_locale":"en_US","og_type":"article","og_title":"Creating New Tables in IRI Workbench - IRI","og_description":"This article demonstrates two ways to create DDL and tables in IRI Workbench for a variety of purposes. Including how to use IRI Workbench to facilitate the creation of new relational database tables for everyday database administrator type jobs, and of course jobs, you would perform in other IRI products.","og_url":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/","og_site_name":"IRI","article_published_time":"2022-04-05T19:38:12+00:00","article_modified_time":"2022-06-28T22:54:52+00:00","og_image":[{"width":512,"height":266,"url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Model-object-DDL.png","type":"image\/png"}],"author":"Chaitali Mitra","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Chaitali Mitra","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/#article","isPartOf":{"@id":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/"},"author":{"name":"Chaitali Mitra","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/9bae14a309616863b027c2d56f532caf"},"headline":"Creating New Tables in IRI Workbench","datePublished":"2022-04-05T19:38:12+00:00","dateModified":"2022-06-28T22:54:52+00:00","mainEntityOfPage":{"@id":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/"},"wordCount":1139,"commentCount":0,"publisher":{"@id":"https:\/\/beta.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Model-object-DDL.png","keywords":["add schema","alter table","create table","create tables","Data Definition Language","data migration","DDL","IRI Workbench","new database tables","schema create","VLDB"],"articleSection":["Data Migration","IRI Workbench","VLDB"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/","url":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/","name":"Creating New Tables in IRI Workbench - IRI","isPartOf":{"@id":"https:\/\/beta.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/#primaryimage"},"image":{"@id":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Model-object-DDL.png","datePublished":"2022-04-05T19:38:12+00:00","dateModified":"2022-06-28T22:54:52+00:00","description":"This article demonstrates two ways to create DDL and tables in IRI Workbench for a variety of purposes. Including how to use IRI Workbench to facilitate the creation of new relational database tables for everyday database administrator type jobs, and of course jobs, you would perform in other IRI products.","breadcrumb":{"@id":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/#primaryimage","url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Model-object-DDL.png","contentUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Model-object-DDL.png","width":512,"height":266},{"@type":"BreadcrumbList","@id":"https:\/\/beta.iri.com\/blog\/iri\/iri-workbench\/create-new-tables-in-iri-workbench\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/beta.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Creating New Tables in IRI Workbench"}]},{"@type":"WebSite","@id":"https:\/\/beta.iri.com\/blog\/#website","url":"https:\/\/beta.iri.com\/blog\/","name":"IRI","description":"Total Data Management Blog","publisher":{"@id":"https:\/\/beta.iri.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/beta.iri.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/beta.iri.com\/blog\/#organization","name":"IRI","url":"https:\/\/beta.iri.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","contentUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","width":750,"height":206,"caption":"IRI"},"image":{"@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/9bae14a309616863b027c2d56f532caf","name":"Chaitali Mitra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/95a11f3d0b709c00df3262bab0152f3a?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/95a11f3d0b709c00df3262bab0152f3a?s=96&d=blank&r=g","caption":"Chaitali Mitra"},"sameAs":["http:\/\/www.iri.com"],"url":"https:\/\/beta.iri.com\/blog\/author\/chaitalim\/"}]}},"jetpack_featured_media_url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2022\/04\/Model-object-DDL.png","_links":{"self":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/15737"}],"collection":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/users\/53"}],"replies":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=15737"}],"version-history":[{"count":12,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/15737\/revisions"}],"predecessor-version":[{"id":15767,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/15737\/revisions\/15767"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/media\/15744"}],"wp:attachment":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=15737"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=15737"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=15737"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}