{"title":"DB Table Deleter","nodeType":"Manipulator","id":"*5lTIm-NFbrB3BYAG","factoryName":"org.knime.database.node.utility.droptable.DBTableDropNodeFactory","factoryId":"org.knime.database.node.utility.droptable.DBTableDropNodeFactory","path":["DB","Utility"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>This node removes a table with the given name from the database described by the incoming DB Connection. This is usually done by executing the SQL command <i>drop</i> .</p>\n        ","shortDescription":"Removes a table from the database using the input DB Connection.","keywords":[],"deprecated":false,"streamable":true,"tags":["DB","Utility","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAAN1wAADdcBQiibeAAAABl0RVh0U29mdHdhcmUAd3d3Lmlua3NjYXBlLm9yZ5vuPBoAAAFnSURBVDiNpZM7L0RRFIW/fY0311wxnuOZEASNiEQzfgAJgmjEIxE0KDREYlSi9mgUalEQP0CiEw3T6KYREqagMF4zxlaRa8wVEyfZzcrJOt9Ze29RVf5zpK5SnssKCXksggVuOd7cja0ka6L28rXKlaoSX0A9MJRA/27gsYj5R8lIcLEHOIjXXZ8Ylok21Eioo8WYXN55e/krvmt60FjNNd8P17b1JNm/Axhbu7HFLC+nC2PSNtxt7LXUGeGlcSn/M0FFiURDd7heIwBKdiakVnKdDMW3EDvb5NKhC84hmjmoxyLSXCuBphodsruLiABFgBtIF5Fi4EFVHwHwT1Fod/TP4fYPkBb3+pGNMgo0fhFEX0mfH3H1h5+0PXitfScBqmcmKAFubSCzwBmQAqyr6oVjBh6LmEMGG8ANYP46iV0+OXcwyAd6f4RY7SVSkCdhy+S+qkwOS5ve5xO2SvUO2I/X5b/r/AHDTw7dZFJJBwAAAABJRU5ErkJggg==","views":[],"inPorts":[{"objectClass":"org.knime.database.port.DBSessionPortObject","color":"cc005b","dataType":"DB Session","optional":false,"name":"Input DB Connection","description":"The DB connection from which to drop the table."}],"outPorts":[{"objectClass":"org.knime.database.port.DBSessionPortObject","color":"cc005b","dataType":"DB Session","optional":false,"name":"Output DB Connection","description":"The DB connection with the table removed."}],"dynInPorts":[],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[{"sectionName":"Options","fields":[{"name":"Database name","description":"The name of the database (or catalogue) to use.","optional":false},{"name":"Schema name","description":"The database schema to read the table from. If not provided, the default schema of the database will be used.","optional":false},{"name":"Table name","description":"Name of the database table to read data from. Must match the table name as it appears in the selected schema.","optional":false},{"name":"If table does not exist","description":"The behavior if the selected table does not exist.\n<ul><li><b>Ignore</b> : Skip the deletion of non-existent tables silently.</li><li><b>Fail</b> : Throw an error and abort node execution.</li></ul>","optional":false},{"name":"If other tables have relations to this table","description":"The behavior if other tables have relations to the selected table.\n<ul><li><b>Ignore</b> : Don&#39;t drop the table from the database.</li><li><b>Delete all related tables</b> : Delete the selected table and all related tables, recursively. This also removes any data in those tables - use with caution!\n  <br />\n  The option is ignored if it is not supported by the database e.g. DB2, Hive, Impala or SQLite.</li></ul>","optional":false}]}],"links":[],"kudos":[],"kudosCount":0,"bundleInformation":{"bundleVersion":"5.12.0.v202606171318","bundleName":"KNIME database nodes","bundleSymbolicName":"org.knime.database.nodes","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.database","featureName":"KNIME Database","featureVersion":"5.12.0.v202606171318","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*0mIkLShcIfCXS7Y-"},"frequentSuccessors":[{"id":"*2bU4AsAAxt0i5C9n","factoryName":"org.knime.database.node.utility.tablecreator.DBTableCreateNodeFactory","probability":0.75},{"id":"*PEWSVICzt9HX-3cd","factoryName":"org.knime.database.node.utility.tableselector.DBTableSelectNodeFactory","probability":0.25}]}