SQL to get the number of associations
CREATE TABLE ADS_ASSOCIATIONS
(ID BIGINT IDENTITY(1,1) NOT NULL,
SOURCE_OBJECT_ID bigint NOT NULL ,
SOURCE_OBJECT_TYPE_ID bigint NOT NULL ,
TARGET_OBJECT_ID bigint NOT NULL ,
TARGET_OBJECT_TYPE_ID bigint NOT NULL ,
RELATIONSHIP VARCHAR(250) NULL,
CONSTRAINT PK_ASSOCIATION_ID PRIMARY KEY(ID))'
); The response should be in all capital letters.
user