addcolumn

Description

Adds a column to a table.

Nested Elements

<columndef>

Attribute Description Required
nameColumn name Yes
typeColumn Type

[INT16|INT32|FLOAT32|FLOAT64|STRING|BLOB| DATE|SHAPE|RASTER|XML|INT64|UUID|CLOB| NSTRING|NCLOB] 		No. Defaults to STRING
nullableAllow Null values. No. Defaults to false
sizeThe size of the column values. Only for string and number types.
scaleNumber of digits after decimal. No. Defaults to 0

Examples

  <sde:sdeconnection id="sde.conn" 
      host="127.0.0.1" password="pass" username="myuser"/>
      
  <sde:addcolumn connection="sde.conn"
      tablename="BUILDINGS">
        <columndef name="BUILD_DATE" type="date" nullable="false"/>
        <columndef name="NAME" type="string" size="50"/>
        <columndef name="AREA" type="float32" size="5" scale="2"/>
  </sde:addcolumn>