73 lines
5.0 KiB
HTML
73 lines
5.0 KiB
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 lang="en-us" xml:lang="en-us">
|
||
|
|
<head>
|
||
|
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
|
||
|
|
<meta name="security" content="public" />
|
||
|
|
<meta name="Robots" content="index,follow" />
|
||
|
|
<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
|
||
|
|
<meta name="DC.Type" content="reference" />
|
||
|
|
<meta name="DC.Title" content="Change a table definition" />
|
||
|
|
<meta name="abstract" content="Changing the definition of a table allows you to add new columns, change an existing column definition (change its length, default value, and so on), drop existing columns, and add and remove constraints." />
|
||
|
|
<meta name="description" content="Changing the definition of a table allows you to add new columns, change an existing column definition (change its length, default value, and so on), drop existing columns, and add and remove constraints." />
|
||
|
|
<meta name="DC.subject" content="ALTER TABLE statement, table, changing definition" />
|
||
|
|
<meta name="keywords" content="ALTER TABLE statement, table, changing definition" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafysqltech.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafyaddcol.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafychgcol.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafyallowable.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafydelcol.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafyorderop.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="../db2/rbafzmstatabl.htm" />
|
||
|
|
<meta name="copyright" content="(C) Copyright IBM Corporation 1998, 2006" />
|
||
|
|
<meta name="DC.Rights.Owner" content="(C) Copyright IBM Corporation 1998, 2006" />
|
||
|
|
<meta name="DC.Format" content="XHTML" />
|
||
|
|
<meta name="DC.Identifier" content="rbafyalter" />
|
||
|
|
<meta name="DC.Language" content="en-us" />
|
||
|
|
<!-- All rights reserved. Licensed Materials Property of IBM -->
|
||
|
|
<!-- US Government Users Restricted Rights -->
|
||
|
|
<!-- Use, duplication or disclosure restricted by -->
|
||
|
|
<!-- GSA ADP Schedule Contract with IBM Corp. -->
|
||
|
|
<link rel="stylesheet" type="text/css" href="./ibmdita.css" />
|
||
|
|
<link rel="stylesheet" type="text/css" href="./ic.css" />
|
||
|
|
<title>Change a table definition</title>
|
||
|
|
</head>
|
||
|
|
<body id="rbafyalter"><a name="rbafyalter"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">Change a table definition</h1>
|
||
|
|
<div><p>Changing the definition of a table allows you to add new columns,
|
||
|
|
change an existing column definition (change its length, default value, and
|
||
|
|
so on), drop existing columns, and add and remove constraints.</p>
|
||
|
|
<div class="section"><p>Table definitions are changed using the SQL ALTER TABLE statement.</p>
|
||
|
|
</div>
|
||
|
|
<div class="section"><p>You can add, change, or drop columns and add or remove constraints
|
||
|
|
all with one ALTER TABLE statement. However, a single column can be referenced
|
||
|
|
only once in the ADD COLUMN, ALTER COLUMN, and DROP COLUMN clauses. That is,
|
||
|
|
you cannot add a column and then alter that column in the same ALTER TABLE
|
||
|
|
statement.</p>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<ul class="ullinks">
|
||
|
|
<li class="ulchildlink"><strong><a href="rbafyaddcol.htm">Add a column</a></strong><br />
|
||
|
|
When you add a new column to a table, the column is initialized with its default value for all existing rows. If NOT NULL is specified, a default value must also be specified.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbafychgcol.htm">Change a column</a></strong><br />
|
||
|
|
You can change a column definition in a table using the ALTER COLUMN clause of the ALTER TABLE statement.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbafyallowable.htm">Allowable conversions</a></strong><br />
|
||
|
|
When you change the data type of an existing column, the old and new attributes must be compatible.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbafydelcol.htm">Delete a column</a></strong><br />
|
||
|
|
You can delete a column using the DROP COLUMN clause of the ALTER TABLE statement.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbafyorderop.htm">Order of operations for ALTER TABLE statement</a></strong><br />
|
||
|
|
An ALTER TABLE statement is performed as this set of steps shows.</li>
|
||
|
|
</ul>
|
||
|
|
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbafysqltech.htm" title="Data definition language (DDL) describes the portion of SQL that allows you to create, alter, and destroy database objects. These database objects include schemas, tables, views, sequences, catalogs, indexes, and aliases.">Data definition language (DDL)</a></div>
|
||
|
|
</div>
|
||
|
|
<div class="relinfo"><strong>Related information</strong><br />
|
||
|
|
<div><a href="../db2/rbafzmstatabl.htm">ALTER TABLE</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|