Create datasets in a relational database

Available with Standard or Advanced license.

While working with a relational database in ArcGIS Pro, you can create tables, feature classes, and database views from the database connection. To add a dataset, right-click the database connection in the Catalog pane and click New. Next, choose the type of dataset to create from the context menu list. This opens the geoprocessing tool corresponding to the dataset type chosen. Provide the input parameters and run the geoprocessing tool to create the dataset in the database.

  • To create a table or view, the connected user must have the required database permissions.
  • To create a feature class, the connected user must have database permissions required to create tables. In addition, the database must support and, if necessary, have been enabled to use a SQL spatial data type.

Note:

You cannot create tables, feature classes, or database views from a database connection to a cloud data warehouse.

Follow these steps to create a nonspatial table, a feature class, or a view.

  1. Connect to the database as a user with database permissions to create tables or views.
  2. In the Catalog pane, right-click the database connection, point to New, and choose the type of dataset to create.

    The geoprocessing tool corresponding to the dataset type you choose opens. These include the following:

  3. Fill in the tool parameters and click Run to create the dataset.

Add attribute fields to the newly created table or feature class. To allow others access to the new table, feature class, or view, grant privileges using the Change Privileges geoprocessing tool.