SQL Server DateTime2(7) fields being created as datWideString(27) in Schema Modeller

Data Abstract
,
1

Hi,

I created a table with a couple of fields defined as

datetime2(7)

and they were created in the schema data table as

datWideString(27)

Cheers
Stu

2

it depends on aux provider, e.g. for ADO?AuxDriver=SQLOLEDB.1 - it will be recognized as WideString(27) but for ADO?AuxDriver=SQLNCLI10.1 - as DateTime

3

Thanks, did not know that. :slight_smile: