Database Objects

Diagrams and diagram properties

How to work with SqlDBM Diagrams

Written by SqlDBM Support
Updated over a week ago

Schemas

How to work with schemas

Written by SqlDBM Support
Updated over a week ago

Subject Areas

How to use Subject Areas

Written by SqlDBM Support
Updated over a week ago

File formats (Snowflake)

How to create and use Snowflake file formats

Written by SqlDBM Support
Updated over a week ago

Tables

How to work with tables in SqlDBM

Written by SqlDBM Support
Updated over a week ago

Snowflake Tables

Working with Snowflake-specific table properties

Written by SqlDBM Support
Updated over a week ago

Azure Synapse Analytics Tables

Maintain Azure Synapse-specific table properties

Written by SqlDBM Support
Updated over a week ago

Columns

How to work with columns in SqlDBM

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

Written by SqlDBM Support
Updated over a week ago

Foreign keys

How to assign foreign keys

Written by SqlDBM Support
Updated over a week ago

Alternate Keys

Alternate keys and how to create them

Written by SqlDBM Support
Updated over a week ago

Indexes

How to create indexes on tables

Written by SqlDBM Support
Updated over a week ago

Clustering keys (Snowflake)

How to create and use clustering keys with Snowflake

Written by SqlDBM Support
Updated over a week ago

Relationships

How to create relationships between objects on a diagram

Written by SqlDBM Support
Updated over a week ago

Notes

Create and maintain notes in your project

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

Written by SqlDBM Support
Updated over a week ago

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

How to create and maintain Snowflake views

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