pacx table create

Creates a new table in the dataverse environment that has previously been selected via pacx auth select

Aliases

pacx create table

Usage

This command can be used to create a new table specifying a minimun set of information. You can simply type

pacx table create --name "My Table"

to create a new table named "My Table" in the solution set as default via pacx solution setDefault. The table schema name will be generated automatically extrapolating only chars, numbers and underscores from the display name,setting them lowercase, prefixed with the solution's publisher prefix. In this case, if the publisher prefix is greg), the generated schema name will be greg_mytable

Arguments

Long Name	Short Name	Required?	Description	Default value	Valid values
name	n	Y	The display name of the table to be created.	-	String
plural	p	N	The collection name of the table to be created.	-	String
schemaName	sn	N	Technical schema name of the table to be created. If not specified, it is inferred from the display name.	-	String
description	d	N	Meaningful description of the table contents/purpose.	-	String
ownership	o	N	Defines if the table records can belong to an user or are organization-owned.	UserOwned	None, UserOwned, TeamOwned, BusinessOwned, OrganizationOwned, BusinessParented, Filtered
isActivity	act	N	Indicates whether the table is an activity or not.	False	true, false
offline	off	N	Indicates whether the table should be enabled for offline or not.	False	true, false
queue	queue	N	Indicates whether records of this table can be added to a queue or not.	False	true, false
feedback	fb	N	Indicates whether user can provide feedbacks to records in this table or not.	False	true, false
notes		N	Indicates whether user can add notes and attachments to the current table or not.	False	true, false
audit	a	N	Indicates whether audit is enabled or not.	True	true, false
connection	conn	N	Indicates whether the current table can partecipate in connection relationships or not.	False	true, false
changeTracking	ct	N	Indicates whether change tracking is enabled or not.	-	Boolean
quickCreate	qc	N	Indicates whether quick create form is enabled or not.	False	Boolean
hasEmail	email	N	Rows in this table can have email addresses (for example, info@contoso.com.). If the table didn’t have an email column, one will be added. This option can only be set.	False	Boolean
primaryAttributeName	pan	N	The display name of the primary attribute for the table. If not specified, is used Name, unless it is required to be an autonumber. In that case, Code is used.	-	String
primaryAttributeSchemaName	pas	N	The schema name of the primary attribute for the table. If not specified, it's inferred from the primary attribute name.	-	String
primaryAttributeDescription	pad	N	A description for the primary attribute of the table.	-	String
primaryAttributeAutoNumberFormat	paan	N	If the primary attribute should be an autonumber, indicates the format for the autonumber (https://learn.microsoft.com/en-us/dynamics365/customerengagement/on-premises/developer/create-auto-number-attributes?view=op-9-1#autonumberformat-options).	-	String
primaryAttributeRequiredLevel	par	N	Requirement level for the primary attribute. If not specified, and autonumber, it's None, otherwise it's ApplicationRequired	-	None, SystemRequired, ApplicationRequired, Recommended
primaryAttributeMaxLength	palen	N	Max length of the primary attribute for the table.	100	Int32
solution	s	N	The name of the solution where the table will be created. If not provided, the default solution will be used.	-	String