Skip To Content

Create datasets in a database

Available with Standard or Advanced license.

While working with your database in ArcGIS Pro, you can create tables, feature classes, and database views directly from the database connection. One of the simplest ways you can add new datasets is to right-click the database in the Catalog pane and click New. Next, select the type of dataset you want to create from the context menu list. This opens the geoprocessing tool corresponding to the dataset type chosen. You can then enter the input parameters and run the geoprocessing tool to create the dataset within 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 and the database must support and have been enabled for a SQL spatial data type.

Steps to create datasets

  1. Create a connection to your database.
  2. In the Catalog pane, right-click the database connection, point to New, and choose the specific type of dataset you want to create.

    This opens the geoprocessing tool corresponding to the dataset type chosen. See the table below for the dataset types that can be created within a database.

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

After creating a table or feature class, the fields view can be used to add attribute fields to the new dataset. To allow access to newly created tables, feature classes, or views, grant privileges using the Change Privileges geoprocessing tool.

New dataset types to create in a database

TypeDescription

Feature class

A collection of features of the same type (such as wells, parcels, and streets) with a common set of attribute fields

Table

Attribute tables used for many purposes

View

A read-only database view you define on tables in your database