Create Table (Data Management)

Summary

Creates a geodatabase table or a dBASE table.

Usage

  • To create a dBASE table in a folder, append the .dbf extension to the Table Name parameter value.

Parameters

LabelExplanationData Type
Table Location

The workspace where the output table will be created.

Workspace
Table Name

The name of the table that will be created.

String
Template Datasets
(Optional)

One or more datasets from which the attribute schema will be used to define the output table. Fields in the template datasets will be added to the output table.

Table View
Configuration Keyword
(Optional)

The configuration keyword that determines the storage parameters of the table in an enterprise geodatabase.

String
Table Alias Name
(Optional)

The alternate name of the output table that will be created.

String
OID Type

Specifies whether the output Object ID field will be 32 bit or 64 bit.

  • Same as templateThe output Object ID field type (32 bit or 64 bit) will be the same as the Object ID field of the first template dataset. This is the default.
  • 64-bitThe output Object ID field will be 64 bit.
  • 32-bitThe output Object ID field will be 32 bit.
String

Derived Output

LabelExplanationData Type
Output Table

The new output table.

Table

arcpy.management.CreateTable(out_path, out_name, {template}, {config_keyword}, {out_alias}, oid_type)
NameExplanationData Type
out_path

The workspace where the output table will be created.

Workspace
out_name

The name of the table that will be created.

String
template
[template,...]
(Optional)

One or more datasets from which the attribute schema will be used to define the output table. Fields in the template datasets will be added to the output table.

Table View
config_keyword
(Optional)

The configuration keyword that determines the storage parameters of the table in an enterprise geodatabase.

String
out_alias
(Optional)

The alternate name of the output table that will be created.

String
oid_type

Specifies whether the output Object ID field will be 32 bit or 64 bit.

  • SAME_AS_TEMPLATEThe output Object ID field type (32 bit or 64 bit) will be the same as the Object ID field of the first template dataset. This is the default.
  • 64_BITThe output Object ID field will be 64 bit.
  • 32_BITThe output Object ID field will be 32 bit.
String

Derived Output

NameExplanationData Type
out_table

The new output table.

Table

Code sample

CreateTable example 1 (Python window)

The following Python window script demonstrates how to use the CreateTable function in immediate mode.

import arcpy
arcpy.env.workspace = "C:/data"
arcpy.management.CreateTable("C:/output", "habitatTemperatures.dbf", 
                             "vegtable.dbf")
CreateTable example 2 (stand-alone script)

The following Python script demonstrates how to use the CreateTable function in a stand-alone script:

# Name: CreateTable_Example2.py
# Description: Create a table to store temperature data in gnatcatcher habitat areas

# Import system modules
import arcpy

# Set workspace
arcpy.env.workspace = "C:/data"

# Set local variables
out_path = "C:/output"
out_name = "habitatTemperatures.dbf"
template = "vegtable.dbf"
config_keyword = ""

# Run CreateTable
arcpy.management.CreateTable(out_path, out_name, template, config_keyword)

Related topics