Custom tables and columns in repository

Applies to: 9.x (current) versions, Article available also for: 8.x, 7.x, 6.x

Dataedo repository is shipped with a number of predefined tables and columns. However, you can add your own custom tables and columns to the repository database.

Custom elements you can add to our repository:

  • Tables
  • Columns to existing tables
  • Schemas
  • User defined functions
  • Stored procedures

Adding columns to existing tables

When you add custom columns to our existing tables please make sure that they either:

  • Are nullable or
  • Have defined default value

Naming convention

Each element you add to the database MUST conform to the following simple naming convention - its name must start with "_".

Example:

  • Custom table: dbo._my_table
  • Custom column in existing table: dbo.modules._my_column

Changing existing schema

It is not allowed to change any of the following:

  • Names of existing tables, columns (and other elements)
  • Data types of existing columns
  • Constraints of existing tables and columns

or add to existing tables:

  • Triggers
  • Constraints
Found issue with this article? Comment below
0
There are no comments. Click here to write the first comment.