Redgate Blog

Posts by
Redgate Data Modeler

12 December 2015

Tip #12 – The quickest possible way to create a new column

In this tip, we will show you how to use the Down arrow to create one or even more new columns. Probably, this is the fastest way of creating new columns in this part of the galaxy. You really have to learn this. Read more

Redgate Data Modeler

11 December 2015

Redgate Data Modeler

11 December 2015

Tip #11 – Redgate Data Modeler reports that my data type is not supported. What can I do?

Sometimes you may want to use a data type that is so new that Redgate Data Modeler doesn’t recognize it. In this case, the application displays a warning that the type is not supported. This validation may be turned off. Get to know how to do it. Read more

Redgate Data Modeler

10 December 2015

Redgate Data Modeler

10 December 2015

Tip #10 – How to use a data type that is not listed in the data types panel

Redgate Data Modeler will never let you get stuck in a data type dead end. Even if the type you need is not listed, it doesn’t mean you cannot use it. Data types you can find in the data types panel are just the most popular ones. Read more

Redgate Data Modeler

10 December 2015

Redgate Data Modeler

10 December 2015

Database Modeling

When we think of the dental office, our first associations are the drill, the pain, and the fear. OK, that sounds bad. Besides taking care of teeth, a dentist has many other obligations that are professional, legal, or both. All of them require proper data management. Read more

Redgate Data Modeler

9 December 2015

Redgate Data Modeler

9 December 2015

Tip #9 – How to create multiple references between two tables

Relationships in the real world may not be as easy as we would like them to be. Sometimes we want to model a situation where one table is refering to the other more than once. Luckily, with Redgate Data Modeler, this is a piece of cake. Read more

Redgate Data Modeler

8 December 2015

Redgate Data Modeler

8 December 2015

Tip #8 – Setting Your Own Names for Primary Key

Sometimes the naming convention you use requires a specific pattern for the primary keys’ names. That’s why you may want to set your own names for each primary key in your database model instead of using default ones. Go on reading to get to know how to do this in… Read more

Redgate Data Modeler

7 December 2015

Redgate Data Modeler

7 December 2015

Tip #7 – How to include comments in SQL script

You can comment on your database objects (tables, columns, views) in Redgate Data Modeler. You can also include this metadata in your database, where it can be accessed by your SQL developers or DBAs. Read more

Redgate Data Modeler

6 December 2015

Redgate Data Modeler

6 December 2015

Tip #6 – How to Create a Multicolumn Primary Key

Primary keys may contain more than one column. Multicolumn primary keys are frequently used for junction tables, which are used to model many-to-many relationships. Read more

Redgate Data Modeler

5 December 2015

Redgate Data Modeler

5 December 2015

Tip #5 – How to quote table names in generated SQL script

Sometimes, you want all identifiers in your SQL script to be quoted. For example, you want them to have a particular case. Luckily, Redgate Data Modeler allows you to quote all SQL identifiers in your generated script to prevent you from any SQL name conflicts. Read more

Redgate Data Modeler

4 December 2015

Redgate Data Modeler

4 December 2015

Tip #4 – How to Make a Column Unique

Sometimes there are columns in a table that don’t belong to primary key, but are still unique. To mark them as a unique, you have to create an alternate (unique) key containing it. Read more

Previous Next

Sicherheit und Compliance

Datenbankmonitoring und Observability

Datenbankänderungsmanagement

Produktivität und Workflow-Automatisierung

KI-bereite Daten

Datenbankmodernisierung

Effizienz und Kostenoptimierung

Cloud-Migration und Workload-Optimierung

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Redgate Blog

Posts by
Redgate Data Modeler

Tip #12 – The quickest possible way to create a new column

Tip #11 – Redgate Data Modeler reports that my data type is not supported. What can I do?

Tip #10 – How to use a data type that is not listed in the data types panel

Database Modeling

Tip #9 – How to create multiple references between two tables

Tip #8 – Setting Your Own Names for Primary Key

Tip #7 – How to include comments in SQL script

Tip #6 – How to Create a Multicolumn Primary Key

Tip #5 – How to quote table names in generated SQL script

Tip #4 – How to Make a Column Unique

2025 Stand der Datenbank-Landschaft

Einführung in PostgreSQL für den Datenprofi

Sicherheit und Compliance

Datenbankmonitoring und Observability

Datenbankänderungsmanagement

Produktivität und Workflow-Automatisierung

KI-bereite Daten

Datenbankmodernisierung

Effizienz und Kostenoptimierung

Cloud-Migration und Workload-Optimierung

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Posts byRedgate Data Modeler

Cookies on red-gate.com

Posts by
Redgate Data Modeler