Available with Standard or Advanced license.
You can create tables in your database when you connect to it from ArcMap provided you have the required database permissions to create a table.
Follow these steps to create a nonspatial table in a database:
- Start ArcCatalog or ArcMap and open the Catalog window.
- Create a connection to your database.
- Right-click the database connection in the Catalog tree, point to New, and click Table.
- Type a name for the table.
Table names must start with a letter and cannot exceed 160 characters.
- If you want, type an alias for the table.
You might have a table name standard that isn't user-friendly. In those cases, create an alias for the table.
- Define the fields for your table.
All tables must contain a unique identifier to be used with ArcGIS. Therefore, ArcGIS automatically adds an ObjectID field to the table. The ObjectID value is populated automatically when you load data into the table.
- Click the next blank row in the Field Name column and type a name.
- Click in the Data Type column next to the new field's name and choose a data type from the drop-down list.
- Optionally create an alias for this field by clicking in the Alias field under Field Properties and typing an alias.
- If you don't want any null values stored in the field, click the field next to Allow NULL values and choose No from the drop-down list.
- Define additional field properties.
For BLOB or text fields, type the maximum length of the field in the Length field. For a date field, you can define a default date in the Default Value field. For raster fields, you can type a description of the raster content. For numeric types, there may be precision or scale values you can set. See ArcGIS field data types.
- Repeat steps a through e for each field you want to add to the table.
- Click Finish to create the table.