Hello!
I use CS2002 + SP3 + FP1.
I use vbs script (a customized CreateSchemaObject.vbs from SDK) to
extend data warehouse with a new class MyClass (this script uses OLE DB
Provider for Commerce Server).
After the script is done, I find new rows in ClsDef and MemDef
tables and automatically created table for my new class (MyClass).
But:
1. My primary key column is marked as "IsPrimaryKey=1" in the
MemDef table, but in the MyClass table it is not - there is no primary
key in this table.
Why? How to change this?
2. Some columns cannot contain nulls. They are successfully marked
as "IsRequired=1" in the MemDef table, but they are all nullable in the
MyClass table.
Why? How to change this?
3. An additional column named "MyClassID" is created in the MyClass
table. Its type is binary(6), and it cannot contain nulls. Also a unique
clustered index is automatically created on this column.
What is this column for? Can I disable it?
--
Yours faithfully,
Alexander Yushchenko
