Documentation

Table of Contents:


    Custom tables and columns in repository

    2018-06-07 2018-06-16
    Applies to: 7.x (current), Article available also for: 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
    Comments (0)