View of Box metadata templates and their fields. One row per (template, field), with template-level columns repeated. Use the CreateMetadataTemplate, ModifyMetadataTemplate, and DeleteMetadataTemplate stored procedures to add, modify, or delete templates and fields.

Table Specific Information

Select

You can retrieve information about the metadata templates available in your enterprise.

SELECT * FROM MetadataTemplates;

You can also retrieve a single template by its identifier:

SELECT * FROM MetadataTemplates WHERE Id = 'e93746cc-03f6-4dee-ab45-01834989950c';

Modifying templates

MetadataTemplates is exposed as a read-only view. To add, modify, or delete a template, call one of the dedicated stored procedures:

• 
  

  CreateMetadataTemplate

  creates a new template and, optionally, seeds it with one or more fields in a single call.
• 
  

  ModifyMetadataTemplate

  modifies the schema of an existing template. The change to apply (add a field, rename an option, reorder fields, and so on) is selected through the Op input.
• 
  

  DeleteMetadataTemplate

  deletes a template and all of its fields.

Columns