Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\dbasfox.21.10.html
<?xml version="1.0" encoding="utf-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html;charset=utf-8" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <!-- MOTW-DISABLED saved from url=(0014)about:internet --> <title>Alter Table Statement</title> <link rel="StyleSheet" href="css/dbasfox.css" type="text/css" media="all" /> <link rel="StyleSheet" href="css/webworks.css" type="text/css" media="all" /> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/context.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/towwhdir.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/wwhpagef.js"></script> <script type="text/javascript" language="JavaScript1.2"> <!-- var WebWorksRootPath = ""; // --> </script> <script type="text/javascript" language="JavaScript1.2"> <!-- // Set reference to top level help frame // var WWHFrame = WWHGetWWHFrame("", true); // --> </script> <script type="text/javascript" language="JavaScript1.2" src="scripts/expand.js"></script> </head> <body class="" style="background-color: #FFFFEE;" onload="WWHUpdate();" onunload="WWHUnload();" onkeydown="WWHHandleKeyDown((document.all||document.getElementById||document.layers)?event:null);" onkeypress="WWHHandleKeyPress((document.all||document.getElementById||document.layers)?event:null);" onkeyup="WWHHandleKeyUp((document.all||document.getElementById||document.layers)?event:null);"> <br /> <div class="WebWorks_Breadcrumbs" style="text-align: left;"> <a class="WebWorks_Breadcrumb_Link" href="dbasfox.21.01.html#106973">16 The dBASE Driver</a> : Alter Table Statement</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="106973">Alter Table Statement</a></div> <div class="Body"><a name="106974">The dBASE driver supports the Alter Table statement to add one or more columns to a table </a>or to delete (drop) a single column.</div> <div class="Body"><a name="106975">The Alter Table statement has the form:</a></div> <div class="syntax_first"><a name="106976">ALTER TABLE </a><span class="EquationVariables">table_name</span> {ADD <span class="EquationVariables">column_name</span> <span class="EquationVariables">data_type </span>| <br />ADD(<span class="EquationVariables">column_name</span> <span class="EquationVariables">data_type </span>[, <span class="EquationVariables">column_name</span> <span class="EquationVariables">data_type</span>]... ) | <br />DROP[COLUMN] <span class="EquationVariables">column_name</span>}</div> <div class="Body"><span class="EquationVariables"><a name="106977">table_name</a></span><span class="Emphasis" style="color: #000000; font-size: 10pt; font-weight: normal;"> </span>is the name of the table to which you are adding or dropping columns.</div> <div class="Body"><span class="EquationVariables"><a name="106978">column_name</a></span> assigns a name to the column you are adding or specifies the column you are dropping.</div> <div class="Body"><span class="EquationVariables"><a name="106979">data_type</a></span> specifies the native data type of each column you add.</div> <div class="Body"><a name="106980">For example, to add two columns to the emp table:</a></div> <div class="syntax_first"><a name="106981">ALTER TABLE emp (ADD startdate date, dept char (10))</a></div> <div class="Body"><a name="106982">You cannot add columns and drop columns in a single statement, and you can drop only </a>one column at a time. For example, to drop a column:</div> <div class="syntax_first"><a name="106983">ALTER TABLE emp DROP startdate</a></div> <div class="Body"><a name="106984">The Alter Table statement fails if you attempt to drop a column upon which other objects, </a>such as indexes or views, are dependent.</div> <script type="text/javascript" language="JavaScript1.2"> <!-- // Clear related topics // WWHClearRelatedTopics(); document.writeln(WWHRelatedTopicsInlineHTML()); // --> </script> </blockquote> <script type="text/javascript" language="JavaScript1.2"> <!-- document.write(WWHRelatedTopicsDivTag() + WWHPopupDivTag() + WWHALinksDivTag()); // --> </script> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de