Need to implement ALTER Table support so that alter statements can be used to alter entity metadata in crm - i.e adding, dropping, changing columns etc.
CREATE TABLE
To create a new Entity in CRM use the CREATE TABLE sql command.
You must specify the primary key column (guid) and the name column - as all entities in CRM have must have these columns.
[x] Can Create new Entity with Id and Name column
You cannot create the table with any additional columns due a limitation with the dynamics crm sdk.
Instead you must first create the table, then use an ALTER statement to add in any additional columns that you want.
ALTER TABLE ADD COLUMN
[x] Can Add Boolean Attribute
[x] Can Add Boolean Attribute with Default True.
[x] Can Add Boolean Attribute with Default False.
[x] Can Add DateTime Attribute.
[x] Can Add Date Attribute.
[x] Can Add Decimal Attribute.
[x] Can Add Decimal Attribute With Precision.
[x] Can Add Decimal Attribute With Precision and Scale.
[x] Can Add Double Attribute.
[x] Can Add Double Attribute With Precision.
[x] Can Add Double Attribute With Precision and Scale.
[x] Can Add Integer Attribute.
[x] Can Add Lookup Attribute.
[x] Can Add Lookup Attribute With Named Constraint.
[x] Can Add Memo Attribute.
[x] Can Add Money Attribute.
[x] Can Add Money Attribute With Precision.
[x] Can Add Money Attribute With Precision and Scale.
[x] Can Add String Attribute.
[x] Can Add String Attribute With MaxSize
ALTER TABLE DROP COLUMN
[ ] Can Drop Boolean Attribute
[ ] Can Drop Boolean Attribute with Default True.
[ ] Can Drop Boolean Attribute with Default False.
[ ] Can Drop DateTime Attribute.
[ ] Can Drop Date Attribute.
[ ] Can Drop Decimal Attribute.
[ ] Can Drop Decimal Attribute With Precision.
[ ] Can Drop Decimal Attribute With Precision and Scale.
[ ] Can Drop Double Attribute.
[ ] Can Drop Double Attribute With Precision.
[ ] Can Drop Double Attribute With Precision and Scale.
[ ] Can Drop Integer Attribute.
[ ] Can Drop Lookup Attribute.
[ ] Can Drop Lookup Attribute With Named Constraint.
[ ] Can Drop Memo Attribute.
[ ] Can Drop Money Attribute.
[ ] Can Drop Money Attribute With Precision.
[ ] Can Drop Money Attribute With Precision and Scale.
Need to implement ALTER Table support so that alter statements can be used to alter entity metadata in crm - i.e adding, dropping, changing columns etc.
CREATE TABLE
To create a new Entity in CRM use the CREATE TABLE sql command. You must specify the primary key column (guid) and the name column - as all entities in CRM have must have these columns.
You cannot create the table with any additional columns due a limitation with the dynamics crm sdk. Instead you must first create the table, then use an ALTER statement to add in any additional columns that you want.
ALTER TABLE ADD COLUMN
ALTER TABLE DROP COLUMN