Types of tables in Dataverse

There are four types of tables in Dataverse:

  • Standard: These are the pre-built set of tables that are included in every instance of Dataverse database. You can change name of these tables and columns of these tables, but you cannot delete any column from these tables. These are the generic tables that can be used across any organization. You can customize them as per your requirement. It is recommended to try to use these tables before creating new custom tables.
  • Complex: These tables contain complex and server-side business logic, including workflows and plugins. Users need P2 or Dynamics 365 license to work on these tables. Care should be taken while working on these tables as they include server-side logic.
  • Restricted: These tables are linked to Dynamics 356 applications for which each user should have the license for that Dynamic 365 application to perform CRUD (Create, Read, Update and Delete) operations.
  • Custom: These are the tables that are created for a specific business requirement.