Switch to: V11V10V9V8V7V6V5

Schema Editor - Schema Objects

Valentina Studio maintains basic schema objects for supported database engines. Below listed all supported schema objects according to their dependencies. You can access to each object of particular type in the Tree View or Column View according to the objects hierarchy.

Valentina Schema Objects

  • Database
    • Function
    • Link (Foreign Key, Binary Link, ObjectPtr Link)
    • Sequence
    • Table
      • Check
      • Field
      • Index
      • Link (Foreign Key, Binary Link, ObjectPtr Link)
      • Method
      • Trigger
      • Unique
    • Trigger
    • Type (Enumeration)
      • Type Value
      • Localization
    • View
      • Trigger

Also each objects has Properties, that can be system or user defined. All properties are shown as individual objects.

SQLite Schema Objects

  • Database
    • Index
    • Link (Foreign Key)
    • Table
      • Check
      • Field
      • Index
      • Link (Foreign Key)
      • Trigger
      • Unique
    • Trigger
    • View
      • Trigger

MySQL Schema Objects

  • Database
    • Function
    • Link (Foreign Key)
    • Table
      • Field
      • Index
      • Link (Foreign Key)
      • Trigger
      • Unique
    • View
      • Trigger

PostgreSQL Schema Objects

  • Database
    • Schema
      • Function
      • Link (Foreign Key)
      • Sequence
      • Table
        • Check
        • Field
        • Index
        • Link (Foreign Key)
        • Trigger
        • Unique
      • Type (Enumeration)
      • View
        • Trigger

SQL Server Schema Objects

  • Database
    • Assembly
    • DDL Trigger
    • Schema
      • Function
      • Link (Foreign Key)
      • Sequence
      • Synonym
      • Table
        • Check
        • Field
        • Index
        • Method (Computed Column)
        • Link (Foreign Key)
        • Trigger
        • Unique
      • Type (Base, Table, Assembly)
      • View
        • Trigger

Also each objects has Properties. All properties are shown as individual objects.

ODBC Schema Objects

  • Database
    • Table
      • Field
      • Index
    • View