How to skip generating foreign key for association fields

Support
#1

Hi,
When I set a field as an association field, this will create a foreign key in database. If I want to skip it, how can I do?

create table CUBATEST_ORDER (
    ID uniqueidentifier,
    VERSION integer not null,
    CREATE_TS datetime2,
    CREATED_BY varchar(50),
    UPDATE_TS datetime2,
    UPDATED_BY varchar(50),
    DELETE_TS datetime2,
    DELETED_BY varchar(50),
    --
    CUSTOMER uniqueidentifier,
    DATE_ datetime2,
    --
    primary key nonclustered (ID)
)^

-- constraints

alter table CUBATEST_ORDER add constraint FK_CUBATEST_ORDER_ON_CUSTOMER foreign key (CUSTOMER) references CUBATEST_CUSTOMER(ID)^


-- indexes

create index IDX_CUBATEST_ORDER_ON_CUSTOMER on CUBATEST_ORDER (CUSTOMER)^
#2

You cannot skip generation of foreign keys. But you can choose a primary key (and hence foreign keys using it) of another type when creating an entity:

image