Database Objects

How to manage entities in SqlDBM project

SqlDBM Support avatar S
21 articles in this collection
Written by SqlDBM Support and Serge Gershkovich

Diagrams and diagram properties

How to work with SqlDBM Diagrams
SqlDBM Support avatar
Written by SqlDBM Support
Updated over a week ago

Schemas

How to work with schemas
SqlDBM Support avatar
Written by SqlDBM Support
Updated over a week ago

Subject Areas

How to use Subject Areas
SqlDBM Support avatar
Written by SqlDBM Support
Updated over a week ago

File formats (Snowflake)

How to create and use Snowflake file formats
SqlDBM Support avatar
Written by SqlDBM Support
Updated over a week ago

Tables

How to work with tables in SqlDBM
SqlDBM Support avatar
Written by SqlDBM Support
Updated over a week ago

Snowflake Tables

Working with Snowflake-specific table properties
SqlDBM Support avatar
Written by SqlDBM Support
Updated over a week ago

Azure Synapse Analytics Tables

Maintain Azure Synapse-specific table properties
SqlDBM Support avatar
Written by SqlDBM Support
Updated over a week ago

Columns

How to work with columns in SqlDBM
SqlDBM Support avatar
Written by SqlDBM Support
Updated over a week ago

Table Templates

Create and reuse common columns across the entire project
S
Written by Serge Gershkovich
Updated yesterday

Primary Keys

How to identify and create primary and keys for your tables
SqlDBM Support avatar
Written by SqlDBM Support
Updated over a week ago

Foreign keys

How to assign foreign keys
SqlDBM Support avatar
Written by SqlDBM Support
Updated over a week ago

Alternate Keys

Alternate keys and how to create them
SqlDBM Support avatar
Written by SqlDBM Support
Updated over a week ago

Indexes

How to create indexes on tables
SqlDBM Support avatar
Written by SqlDBM Support
Updated over a week ago

Clustering keys (Snowflake)

How to create and use clustering keys with Snowflake
SqlDBM Support avatar
Written by SqlDBM Support
Updated over a week ago

Relationships

How to create relationships between objects on a diagram
SqlDBM Support avatar
Written by SqlDBM Support
Updated over a week ago

Notes

Create and maintain notes in your project
SqlDBM Support avatar
Written by SqlDBM Support
Updated over a week ago

Check Constraints (SQL Server, MySQL, PostgreSQL)

How to create and use check constrains in supported databases
SqlDBM Support avatar
Written by SqlDBM Support
Updated over a week ago

Views (Snowflake, Azure Synapse Analytics, MS SQL Server)

How to create and maintain Snowflake views
SqlDBM Support avatar
Written by SqlDBM Support
Updated over a week ago

Stored-Procedures and User-Defined Functions (UDF)

How to create and work with UDF functions and stored procedures
S
Written by Serge Gershkovich
Updated over a week ago

Snowflake Sequences and Autoincrement/Identity

Creating and working with auto-generated sequences for columns
S
Written by Serge Gershkovich
Updated over a week ago

Object Flagging (Standard Enterprise)

Flags at object and column level
S
Written by Serge Gershkovich
Updated over a week ago