Is it possible to create NONCLUSTERED PrimaryKey while still using the PK flag to identify them? I'm trying to achieve this in sql server.

is it possible to get an example to SQL Server 14? I'm don't know anything of java

How should I handle array data types from Postgres 9.2 in Vertabelo. 

- Can I declare them visually?

- Can I create indexes on them?

- If not, is there a workaround.

Is it possible to add the "FK" in the "properties" column of the fields that are foreign keys in some table, just like it says "PK" for the primary key?

Is there a way to avoid Vertabelo to open multiple browser tabs (each time I open a document/model ) ?

We have a fact table in a physical data model.  Even though we have over 120 columns in the table, only a few are visible regardless of how we resize it.  Is there a limit to how many columns show in the table?  Can we modify it?

Please add support for Postgres 11!!  Unique indexes. Sprocs.

Hi there!

I generated a migration SQL script for Postgres physical data Model, but it didn't work properly.

One of the changes was setting a default for a timestamp column, using now() function as the default value.

The ALTER TABLE command generated by the migration feature was:

-- Column: created_at.
ALTER TABLE rq_forms
ALTER created_at SET DEFAULT 'now()';

However, it creates the default with a fixed timestamp, the date and time of the ALTER TABLE execution.

The expected behavior was setting now() function as the default, not the fixed date and time.

This is the correct script the migration feature should generate: 

-- Column: created_at.
ALTER TABLE rq_forms
ALTER created_at SET DEFAULT now(); --> Without the single quotes.

Just to mention, the CREATE TABLE is working fine, setting the now() function properly when I generate the SQL Script for the same table in the model as seen below. Just ALTER TABLE generated by the migration has the bug.

-- Its OK!

CREATE TABLE rq_forms (
id serial NOT NULL,
created_at timestamp NOT NULL DEFAULT now(),
updated_at timestamp NULL,

(...)

One more request:

Vertabelo could have the type "timestamp with time zone" in the Type windows predefined options (in the Date and time section).

The "timestamp" option creates a "timestamp without time zone" column.

It would be nice to have the option to choose between with or without time zone in Vertabelo.

I hope I could help improving Vertabelo.

Regards,

Fernando dos Santos.

There should be a way to "dock" a table to a subject area (SA) so that when I move the SA, all the tables docked to it move too.