<html> <head> <title>Interface XTableAlteration</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <link rel="stylesheet" type="text/css" href="../../../../../idl.css"> </head> <body> <div id="adc-idlref"> <a name="_top_"> </a><table class="navimain" border="0" cellpadding="3"> <tr> <td class="navimain"><a href="../../module-ix.html" class="navimain">Overview</a></td> <td class="navimain"><a href="module-ix.html" class="navimain">Module</a></td> <td class="navimain"><a href="XTableAlteration-xref.html" class="navimain">Use</a></td> <td class="navimainnone">Devguide</td> <td class="navimain"><a href="../../../../../index-files/index-1.html" class="navimain">Index</a></td> </tr> </table> <table class="navisub" border="0" cellpadding="0"> <tr> <td class="navisub"><a href="#MethodsSummary" class="navisub">Methods' Summary</a></td> <td class="navisub">Attributes' Summary</td> <td class="navisub"><a href="#MethodsDetails" class="navisub">Methods' Details</a></td> <td class="navisub">Attributes' Details</td> </tr> </table> <hr> <table border="0" width="100%" cellpadding="5" cellspacing="3" class="title-table" style="margin-bottom:6pt;"> <tr> <td><p class="namechain"><a href="../../../../../module-ix.html" class="namechain">::</a> <a href="../../../../module-ix.html" class="namechain">com</a> :: <a href="../../../module-ix.html" class="namechain">sun</a> :: <a href="../../module-ix.html" class="namechain">star</a> :: <a href="../module-ix.html" class="namechain">sdb</a> :: <a href="module-ix.html" class="namechain">tools</a> :: </p> </td> </tr> <tr> <td class="title"><table class="title-table" width="99%"> <tr> <td width="25%" class="title2">unpublished </td> <td width="50%" class="title">interface XTableAlteration</td> <td width="*"/></tr> </table> </td> </tr> <tr> <td><dl> <dt><b>Base Interfaces</b></dt> <dd><pre style="font-family:monospace;"><strong>XTableAlteration</strong> ┗ <a href="XConnectionSupplier.html">XConnectionSupplier</a> ┗ ::com::sun::star::<a href="../../lang/module-ix.html">lang</a>::<a href="../../lang/XInitialization.html">XInitialization</a> </pre></dd> <dd><a name/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="crosstitle"> <tr> <td class="imsum_left"><a href="XConnectionSupplier.html">XConnectionSupplier</a></td> <td class="imsum_right"><dl> <dt>(referenced interface's summary:)</dt> <dd>allows to access the active connection </dd> </dl> </td> </tr> </table> </dd> </dl> </td> </tr> <tr> <td><dl> <dt><b>Usage Restrictions</b></dt> <dd><i>not published</i></dd> <dt><b>Description</b></dt> <dd>allows to alter a table. </dd> <dt><b>Since </b></dt> <dd>OOo 3.3</dd> <dt><b>See also</b></dt> <dd>::com::sun::star::<a href="../module-ix.html">sdb</a>::<a href="../DataSource.html">DataSource</a>::<a href="../DataSource.html#Settings">Settings</a>, ::com::sun::star::<a href="../../sdbcx/module-ix.html">sdbcx</a>::<a href="../../sdbcx/ColumnDescriptor.html">ColumnDescriptor</a>, ::com::sun::star::<a href="../../sdbcx/module-ix.html">sdbcx</a>::<a href="../../sdbcx/XAlterTable.html">XAlterTable</a>, ::com::sun::star::<a href="../../sdbcx/module-ix.html">sdbcx</a>::<a href="../../sdbcx/XAppend.html">XAppend</a>, ::com::sun::star::<a href="../../sdbcx/module-ix.html">sdbcx</a>::<a href="../../sdbcx/XDrop.html">XDrop</a></dd> </dl> </td> </tr> </table> <hr> <a name="MethodsSummary"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Methods' Summary</td> </tr> <tr> <td class="imsum_left"><a href="#alterColumnByName">alterColumnByName</a></td> <td class="imsum_right">alter the column defined by name </td> </tr> <tr> <td class="imsum_left"><a href="#addColumn">addColumn</a></td> <td class="imsum_right">creates a new object using the given descriptor and appends it to the related container. <b> Note: </b> The descriptor will not be changed and can be used again to append another object. </td> </tr> <tr> <td class="imsum_left"><a href="#dropColumn">dropColumn</a></td> <td class="imsum_right">drops an object of the related container identified by its name. </td> </tr> </table> <a name="MethodsDetails"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle">Methods' Details</td> </tr> <tr> <td class="imdetail"><a name="alterColumnByName" class="membertitle">alterColumnByName</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-method" bgcolor="#ffffff" align="center"> <tr> <td><table class="table-in-method" border="0"> <tr> <td valign="top" colspan="3">void</td> </tr> <tr> <td valign="top"><b>alterColumnByName</b>(</td> <td valign="top">[in] ::com::sun::star::<a href="../../beans/module-ix.html">beans</a>::<a href="../../beans/XPropertySet.html">XPropertySet</a></td> <td valign="bottom"> table,</td> </tr> <tr> <td/><td valign="top">[in] string</td> <td valign="bottom"> columnName,</td> </tr> <tr> <td/><td valign="top">[in] ::com::sun::star::<a href="../../beans/module-ix.html">beans</a>::<a href="../../beans/XPropertySet.html">XPropertySet</a></td> <td valign="bottom"> columnDescriptor )</td> </tr> <tr> <td valign="top" align="right">raises( </td> <td valign="top" colspan="2">::com::sun::star::<a href="../../sdbc/module-ix.html">sdbc</a>::<a href="../../sdbc/SQLException.html">SQLException</a> );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>alter the column defined by name </dd> <dt><b>Parameter table</b></dt> <dd>the table to be altered </dd> <dt><b>Parameter columnName</b></dt> <dd>the name of the column to be changed </dd> <dt><b>Parameter columnDescriptor</b></dt> <dd>the column descriptor with the information of the new column definition </dd> <dt><b>Throws</b></dt> <dd>com::sun::star::sdbc::SQLException </dd> <dt><b>See also</b></dt> <dd>::com::sun::star::<a href="../../sdbcx/module-ix.html">sdbcx</a>::<a href="../../sdbcx/XAlterTable.html">XAlterTable</a></dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="addColumn" class="membertitle">addColumn</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-method" bgcolor="#ffffff" align="center"> <tr> <td><table class="table-in-method" border="0"> <tr> <td valign="top" colspan="3">void</td> </tr> <tr> <td valign="top"><b>addColumn</b>(</td> <td valign="top">[in] ::com::sun::star::<a href="../../beans/module-ix.html">beans</a>::<a href="../../beans/XPropertySet.html">XPropertySet</a></td> <td valign="bottom"> table,</td> </tr> <tr> <td/><td valign="top">[in] ::com::sun::star::<a href="../../beans/module-ix.html">beans</a>::<a href="../../beans/XPropertySet.html">XPropertySet</a></td> <td valign="bottom"> descriptor )</td> </tr> <tr> <td valign="top" align="right">raises( </td> <td valign="top" colspan="2">::com::sun::star::<a href="../../sdbc/module-ix.html">sdbc</a>::<a href="../../sdbc/SQLException.html">SQLException</a> );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>creates a new object using the given descriptor and appends it to the related container. <b> Note: </b> The descriptor will not be changed and can be used again to append another object. </dd> <dt><b>Parameter table</b></dt> <dd>the table to be altered </dd> <dt><b>Parameter descriptor</b></dt> <dd>the descriptor which should be serve to append a new object </dd> <dt><b>Throws</b></dt> <dd>com::sun::star::sdbc::SQLException if a database access error occurs. </dd> <dt><b>See also</b></dt> <dd>::com::sun::star::<a href="../../sdbcx/module-ix.html">sdbcx</a>::<a href="../../sdbcx/XAppend.html">XAppend</a></dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="dropColumn" class="membertitle">dropColumn</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-method" bgcolor="#ffffff" align="center"> <tr> <td><table class="table-in-method" border="0"> <tr> <td valign="top" colspan="3">void</td> </tr> <tr> <td valign="top"><b>dropColumn</b>(</td> <td valign="top">[in] ::com::sun::star::<a href="../../beans/module-ix.html">beans</a>::<a href="../../beans/XPropertySet.html">XPropertySet</a></td> <td valign="bottom"> table,</td> </tr> <tr> <td/><td valign="top">[in] string</td> <td valign="bottom"> columnName )</td> </tr> <tr> <td valign="top" align="right">raises( </td> <td valign="top" colspan="2">::com::sun::star::<a href="../../sdbc/module-ix.html">sdbc</a>::<a href="../../sdbc/SQLException.html">SQLException</a> );</td> </tr> </table> <hr> <dl> <dt><b>Description</b></dt> <dd>drops an object of the related container identified by its name. </dd> <dt><b>Parameter table</b></dt> <dd>the table to be altered </dd> <dt><b>Parameter columnName</b></dt> <dd>the name of the column to be dropped </dd> <dt><b>Throws</b></dt> <dd>com::sun::star::sdbc::SQLException if a database access error occurs. </dd> <dt><b>See also</b></dt> <dd>::com::sun::star::<a href="../../sdbcx/module-ix.html">sdbcx</a>::<a href="../../sdbcx/XDrop.html">XDrop</a></dd> </dl> </td> </tr> </table> </td> </tr> </table> <a href="#_top_">Top of Page</a><hr size="3"><p class="copyright" align="center">Copyright © 2000, 2012 LibreOffice contributors and/or their affiliates. All rights reserved.</p><p class="copyright" align="center">LibreOffice was created by The Document Foundation, based on OpenOffice.org, which is Copyright 2000, 2010 Oracle and/or its affiliates.</p><p class="copyright" align="center">The Document Foundation acknowledges all community members, please find more info <a href="http://www.libreoffice.org/about-us/credits/" target="_blank">at our website</a>.<p> </p><p class="copyright" align="center"><a href="http://www.libreoffice.org/privacy" target="_blank">Privacy Policy</a> | <a href="http://www.libreoffice.org/imprint" target="_blank">Impressum (Legal Info)</a> | Copyright information: The source code of LibreOffice is licensed under the GNU Lesser General Public License (<a href="http://www.libreoffice.org/download/license/" target="_blank">LGPLv3</a>). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our <a href="http://wiki.documentfoundation.org/TradeMark_Policy" target="_blank">trademark policy</a>.</p> </div> <!-- id="adc-idlref" --> </body> </html>
