Documentation

Table of Contents:


    Custom tables and columns in repository

    Applies to: 9.x (current), 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.

    By continuing to use our website, you consent to the use of cookies in accordance with our Privacy Policy (updated 28-04-2020).
    Accept