<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html><!-- InstanceBegin template="/Templates/main.dwt" codeOutsideHTMLIsLocked="false" --> <head> <!-- InstanceBeginEditable name="doctitle" --> <title>Optimize</title> <!-- InstanceEndEditable --> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <!-- InstanceBeginEditable name="head" --> <link href="ss.css" rel="stylesheet" type="text/css"> <!-- InstanceEndEditable --> </head> <body bgcolor="#FFFFFF" text="#666666"> <table width="100%" border="1" cellpadding="1" cellspacing="1" bordercolor="#CCCCCC"> <tr> <td bgcolor="#CCCCCC"><h3><font color="#999999">DarkSide SQL Mini Help</font></h3></td> </tr> </table> <table width="100%" border="1" cellpadding="1" cellspacing="1" bordercolor="#CCCCCC"> <!--DWLayoutTable--> <tr> <td width="164" height="305" valign="top"><table width="100%" border="1" cellpadding="1" cellspacing="1" bordercolor="#CCCCCC"> <tr> <td><a href="index.htm">Home</a></td> </tr> <tr> <td><a href="intro.htm">Introduction</a></td> </tr> <tr> <td><a href="using.htm">Using The Library</a></td> </tr> <tr> <td><a href="api_ref.htm">API Reference</a></td> </tr> <tr> <td><strong>SQL Commands</strong></td> </tr> <tr> <td><div align="center"><a href="sql_ct.htm">CREATE TABLE</a></div></td> </tr> <tr> <td><div align="center"><a href="sql_dd.htm">DROP DATABASE</a></div></td> </tr> <tr> <td><div align="center"><a href="sql_dt.htm">DROP TABLE</a></div></td> </tr> <tr> <td><div align="center"><a href="sql_use.htm">USE</a></div></td> </tr> <tr> <td><div align="center"><a href="sql_i.htm">INSERT</a></div></td> </tr> <tr> <td><div align="center"><a href="sql_u.htm">UPDATE</a></div></td> </tr> <tr> <td><div align="center"><a href="sql_d.htm">DELETE</a></div></td> </tr> <tr> <td><div align="center"><a href="sql_s.htm">SELECT</a></div></td> </tr> <tr> <td><div align="center"><a href="sql_o.htm">OPTIMIZE</a></div></td> </tr> <tr> <td><a href="types.htm">Data Types</a></td> </tr> <tr> <td><a href="oprs.htm">Operators</a></td> </tr> <tr> <td><a href="bugs.htm">Bugs</a></td> </tr> <tr> <td><a href="lic.htm">License</a></td> </tr> <tr> <td><a href="tps.htm">Third-party software</a></td> </tr> <tr> <td><a href="abt.htm">About</a></td> </tr> </table></td> <!-- InstanceBeginEditable name="txt" --> <td width="398" valign="top"><p><strong>OPTIMIZE</strong></p> <p>The OPTIMIZE command permanently removes deleted records from the data file of the table.</p> <p>Syntax:<br> <font color="#990000">OPTIMIZE table</font></p> <p> </p></td> <!-- InstanceEndEditable --></tr> <tr> <td height="58" colspan="2" valign="top"><div align="center">© 2003 <a href="mailto:vijaymathewp@yahoo.co.in">LogicMatrix</a></div></td> </tr> </table> </body> <!-- InstanceEnd --></html>
By viewing downloads associated with this article you agree to the Terms of use and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.
This article, along with any associated source code and files, is licensed under The BSD License
Math Primers for Programmers