I like MySQL's SHOW CREATE TABLE, so I created something similar with arcpy. One script reads the table and prints a list of field information that I can modify as desired and use to create a new feature or table.
import arcpy
from arcpy import env
env.workspace = r"C:\Path\To\file.gdb"
print env.workspace
print
tableList = arcpy.ListFeatureClasses()
print tableList
for table in tableList:
print
print table
dbTable = env.workspace + "\\" + table
fieldList = arcpy.ListFields(dbTable)
print '\t['
for field in fieldList:
print '\t["' + field.name + '",',
if (field.type == "String"):
print '"TEXT", ',
print '"' + str(field.length) + '",',
else:
print ("\"{0}\", ".format(field.type).upper()),
print '"
print '"' + field.aliasName + '",',
if len(field.domain):
print '"' + field.domain + '"],',
else:
print '"
print '"
print '\t]'
This script produces something like:
businesses
[
["OBJECTID", "OID", "
["Business", "TEXT", "50", "Business Name", "
["Address", "TEXT", "50", "Business Address", "
["City", "TEXT", "20", "Business City", "
["Zip", "TEXT", "10", "Business Zip", "
["Phone", "TEXT", "16", "Business Phone", "
["GlobalID", "GLOBALID", "
["CreationDate", "DATE", "
["Creator", "TEXT", "50", "Creator", "
["EditDate", "DATE", "
["Editor", "TEXT", "50", "Editor", "
["Shape", "GEOMETRY", "
["POINT_X", "DOUBLE", "
["POINT_Y", "DOUBLE", "
]
I then modify the list by modifying/removing/adding fields. From there, I recreate an empty table/feature using something like this (this is for a feature so there are some geometry functions added).
# Import system modules
import arcpy
from arcpy import env
# name of geodatabase
geoDB = r"C:\Path\To\file.gdb"
# set environment settings
env.workspace = geoDB
def new_feature(dbFeature, dbAttributes, geoDB):
# create the table
print "\nCreating feature: " + dbFeature
# set local variables
geometry_type = "POINT"
template = "#"
has_m = "DISABLED"
has_z = "DISABLED"
# Use SpatialReference to set object reference - system name, projection file or authority code
spatial_reference = arcpy.SpatialReference("WGS 1984 Web Mercator (auxiliary sphere)")
# spatial_reference = arcpy.SpatialReference("WGS 1984")
# Execute CreateFeatureclass
# CreateFeatureclass_management (out_path, out_name, {geometry_type}, {template}, {has_m}, {has_z}, {spatial_reference},
# {config_keyword}, {spatial_grid_1}, {spatial_grid_2}, {spatial_grid_3})
arcpy.CreateFeatureclass_management(geoDB, dbFeature, geometry_type, template, has_m, has_z, spatial_reference)
# add the fields
print "Adding attributes: "
for new_field in dbAttributes:
# add new field
print "\t" + new_field[0]
# all fields using domains are non-nullable
if (new_field[4] == "#"):
nullable = "NULLABLE"
else:
nullable = "NON_NULLABLE"
# AddField_management (in_table, field_name, field_type, {field_precision}, {field_scale},
# {field_length}, {field_alias}, {field_is_nullable}, {field_is_required}, {field_domain})
arcpy.AddField_management(dbFeature,new_field[0],new_field[1],"#","#",
new_field[2],new_field[3],nullable,"NON_REQUIRED",new_field[4])
# assign default value as specified
if ( new_field[5] <> "#" ) :
# AssignDefaultToField_management (in_table, field_name, default_value, {subtype_code})
arcpy.AssignDefaultToField_management(dbFeature,new_field[0],new_field[5],"#")
if __name__ == "__main__":
# Fields: [ 0:Name, 1:Type, 2:Size, 3:Alias, 4:Domain, 5:Default] use "#" for blanks
dbFeature = new_business"
dbAttributes = [
["Business", "TEXT", "50", "Business Name", "#", "#"],
["Address", "TEXT", "50", "Business Address", "#", "#"],
["City", "TEXT", "20", "Business City", "#", "#"],
["Zip", "TEXT", "10", "Business Zip", "#", "#"],
["Phone", "TEXT", "16", "Business Phone", "#", "#"],
["Licensed","TEXT","1","Business Licensed","YN","?"], # added domain choices: ?, Y, N
]
new_feature(dbFeature, dbAttributes, geoDB)
print
print "Processing complete."
This gives you the basic workings of the process. Except for the geometry, creating a data table is similar. You can capture more of the field's properties in the first script to use in the second (field.editable, field.precision, etc.). Hope this helps.
