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)^