DDL for collection properties

Question

Question

Eduard Lebedyuk · May 24, 2017

How do I write DDL script for collection properties?

For example I want to create the following class:

Class SQLUser.Person {

Property Name As %String;

Property FavoriteColors As list Of %String;

}

My DDL script looks like this:

CREATE TABLE Person (Name varchar(50), FavoriteColors ???)

Discussion (4)1

Log in or sign up to continue

Matthew Giesmann · May 24, 2017

In general, "list of ___" properties don't play well with SQL. Looks like we just present the list as a string.

Using the Generate CREATE TABLE statement feature of WinSQL for Sample.Person gives:

FavoriteColors VARCHAR(4096)

0 0

Vitaliy Serdtsev · May 24, 2017

E.g.:

CREATE TABLE Person (Name varchar(50), FavoriteColors %Collection.ListOfDT)

CREATE TABLE Person (Name varchar(50), FavoriteColors %List)

CREATE TABLE Person (Name varchar(50), FavoriteColors %ListOfDataTypes)

2 0

score 0 · Answer 1 · 2017-05-24T10:58:49-04:00

Eduard Lebedyuk · May 24, 2017

I thought there's maybe some special keyword.

0 0

score 0 · Answer 2 · 2017-05-24T11:14:27-04:00

Vitaliy Serdtsev · May 24, 2017

0 0