| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" |
| "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
| <!-- |
| |
| Licensed to the Apache Software Foundation (ASF) under one |
| or more contributor license agreements. See the NOTICE file |
| distributed with this work for additional information |
| regarding copyright ownership. The ASF licenses this file |
| to you under the Apache License, Version 2.0 (the |
| "License"); you may not use this file except in compliance |
| with the License. You may obtain a copy of the License at |
| |
| http://www.apache.org/licenses/LICENSE-2.0 |
| |
| Unless required by applicable law or agreed to in writing, |
| software distributed under the License is distributed on an |
| "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| KIND, either express or implied. See the License for the |
| specific language governing permissions and limitations |
| under the License. |
| |
| --> |
| <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr"> |
| <head> |
| <title>Create Table Dialog</title> |
| <link rel="stylesheet" href="ide.css" title="Oracle BLAFDoc" type="text/css"/> |
| </head> |
| |
| <body> |
| <p><a id="org.netbeans.modules.db.explorer.actions.CreateTableAction" name="org.netbeans.modules.db.explorer.actions.CreateTableAction"></a></p> |
| <div id="NBCSH5366"><!-- infolevel="all" infotype="General" --><a id="sthref795" name="sthref795"></a> |
| <h1>Create Table Dialog</h1> |
| <a name="BEGIN" id="BEGIN"></a> |
| <p>Use to create a table, add columns, specify parameters for columns, and select an owner for the table. |
| <object classid="java:org.netbeans.modules.javahelp.BrowserDisplayer"> |
| <param name="content" value="http://www.oracle.com/pls/topic/lookup?ctx=nb8200&id=NBDAG1801"> |
| <param name="text" value="<html><u>How?</u></html>"> |
| <param name="textFontSize" value="medium"> |
| <param name="textColor" value="blue"> |
| </object> |
| </p> |
| |
| <table summary="User interface elements and descriptions" dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> |
| <col width="24%" /> |
| <col width="*" /> |
| <thead> |
| <tr align="left" valign="top"> |
| <th align="left" valign="bottom" id="r1c1-t6">Element</th> |
| <th align="left" valign="bottom" id="r1c2-t6">Description</th> |
| </tr> |
| </thead> |
| <tbody> |
| <tr align="left" valign="top"> |
| <td align="left" id="r2c1-t6" headers="r1c1-t6"> |
| <p>Table Name</p> |
| </td> |
| <td align="left" headers="r2c1-t6 r1c2-t6">Enter the name of the table.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r3c1-t6" headers="r1c1-t6"> |
| <p>Add Column</p> |
| </td> |
| <td align="left" headers="r3c1-t6 r1c2-t6">Click to add a new column.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r4c1-t6" headers="r1c1-t6"> |
| <p>Remove</p> |
| </td> |
| <td align="left" headers="r4c1-t6 r1c2-t6">Click to remove the selected column.</td> |
| </tr> |
| </tbody> |
| </table> |
| <br /> |
| <!-- --> |
| <a id="NBCSH5370" name="NBCSH5370"></a> |
| <p><b>Creating Columns</b></p> |
| <p>When the Create Table dialog opens, one column is displayed in the dialog box, ready to be configured.</p> |
| |
| <table summary="User interface elements and descriptions" dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> |
| <col width="24%" /> |
| <col width="*" /> |
| <thead> |
| <tr align="left" valign="top"> |
| <th align="left" valign="bottom" id="r1c1-t7">Element</th> |
| <th align="left" valign="bottom" id="r1c2-t7">Description</th> |
| </tr> |
| </thead> |
| <tbody> |
| <tr align="left" valign="top"> |
| <td align="left" id="r2c1-t7" headers="r1c1-t7"> |
| <p>Key</p> |
| </td> |
| <td align="left" headers="r2c1-t7 r1c2-t7">Select to indicate the primary key for the table. When you select this, <b>Index</b> and <b>Unique</b> are also selected.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r3c1-t7" headers="r1c1-t7"> |
| <p>Index</p> |
| </td> |
| <td align="left" headers="r3c1-t7 r1c2-t7">Used for indexing the database by column name.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r4c1-t7" headers="r1c1-t7"> |
| <p>Null</p> |
| </td> |
| <td align="left" headers="r4c1-t7 r1c2-t7">Select to have an unknown or missing value represented.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r5c1-t7" headers="r1c1-t7"> |
| <p>Column Name</p> |
| </td> |
| <td align="left" headers="r5c1-t7 r1c2-t7">Enter the name of the column in this field. Use underscore instead of hyphens.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r6c1-t7" headers="r1c1-t7"> |
| <p>Data Type</p> |
| </td> |
| <td align="left" headers="r6c1-t7 r1c2-t7">Select the data type for the column from the list.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r7c1-t7" headers="r1c1-t7"> |
| <p>Size</p> |
| </td> |
| <td align="left" headers="r7c1-t7 r1c2-t7">Specify the size of the column. The default is <code dir="ltr">0</code>.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r8c1-t7" headers="r1c1-t7"> |
| <p>Scale</p> |
| </td> |
| <td align="left" headers="r8c1-t7 r1c2-t7">Specify the scale of the column.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r9c1-t7" headers="r1c1-t7"> |
| <p>Comment</p> |
| </td> |
| <td align="left" headers="r9c1-t7 r1c2-t7">Enter any comment you want to associate with the column.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r10c1-t7" headers="r1c1-t7"> |
| <p>Default value</p> |
| </td> |
| <td align="left" headers="r10c1-t7 r1c2-t7">Specify the default value of the column.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r11c1-t7" headers="r1c1-t7"> |
| <p>Check</p> |
| </td> |
| <td align="left" headers="r11c1-t7 r1c2-t7">When selected, the IDE performs a check of the column to determine if it meets the required criteria.</td> |
| </tr> |
| <tr align="left" valign="top"> |
| <td align="left" id="r12c1-t7" headers="r1c1-t7"> |
| <p>Check constraint</p> |
| </td> |
| <td align="left" headers="r12c1-t7 r1c2-t7">Enter the condition that defines valid data when adding or updating an entry in the column.</td> |
| </tr> |
| </tbody> |
| </table> |
| <br /> |
| <!-- --> |
| <a id="NBCSH5382" name="NBCSH5382"></a> |
| <hr><p><b>Related Topics</b></p> |
| <p><i>Developing Applications with NetBeans IDE</i>, |
| <object classid="java:org.netbeans.modules.javahelp.BrowserDisplayer"> |
| <param name="content" value="http://www.oracle.com/pls/topic/lookup?ctx=nb8200&id=NBDAG1790"> |
| <param name="text" value="<html><u>"Working and Connecting with Databases"</u></html>"> |
| <param name="textFontSize" value="medium"> |
| <param name="textColor" value="blue"> |
| </object> |
| </p> |
| |
| <!-- --> |
| <!-- Start Footer --> |
| |
| |
| <table summary="" cellspacing="0" cellpadding="0" width="100%"> |
| <tr> |
| <td align="left" width="86%"><a href="legal_notice.htm"> |
| Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements; and to You under the Apache License, Version 2.0.</a> |
| </td> |
| </tr> |
| </table> |
| <!-- --> |
| </body> |
| </html> |