drop dataverse test if exists; | |
create dataverse test; | |
use dataverse test; | |
create type test.AddressType as open { | |
number: int32, | |
street: string, | |
city: string | |
}; | |
create type test.CustomerType as closed { | |
cid: int32, | |
name: string, | |
cashBack: int32, | |
age: int32?, | |
address: AddressType?, | |
lastorder: { | |
oid: int32, | |
total: float | |
} | |
}; | |
create dataset test.Customers(CustomerType) primary key cid; | |
drop dataset test.Customers; | |