Devart Forums

I use sql server/oracle/firebird,I offten convert tablen structs with different database.
So I think If TUniMeta MetaDataKind support DataType Names(Only DataType ID is very trouble!) ,I will Create Table SQL and convert table structs very easy!

Constraints of MetaDataKind can not support foreign key detail infomation.

such as foreign key SQL:

ALTER TABLE ORDERFORM ADD FOREIGN KEY (WAREHOUSEID) REFERENCES WAREHOUSE (WAREHOUSEID) ON DELETE SET NULL ON UPDATE CASCADE;

TUniMeta dont support REFERENCES TableName and FieldName and CASCADE!

I think you can expand Constraints of MetaDataKind,Add New Field Name :
REFERENCES_TABLENAME And REFERENCES_Columns and CASCADE, Dont Use new MetaDataKind !

Hello,

Please specify why you need data type names and how you want to use them. Data type names are different in different database servers.
We will investigate the possibility of extending information about constraints that is returned by TUniMetaData.

I use data type names to Create Table SQL,Such as Convert MSSQL Table Structs TO Firebird .Maybe some DataBase Get data type names is very difficult! But it is not necessary! you can add data type Names in MetaDataKind=column if it is possible to realize!

We will add this functionality in one of the next UniDAC builds.