What is the maximum lenght of a datatable if it was extracted from a database?

Help Activities
, ,
1

Hello everyone! I would like to know if when I use the activity of extracting a table from a database using a query to it, the allowed size of the columns in the datatable object that is generated is the same as that established in the database.

Thank you so much!

2

Hi @emIT_User,

The maximum number of columns allowed in a DataSet, across all its tables, is 16,000 columns . According to MSDN DataTable Class “The maximum number of rows that a DataTable can store is 16,777,216”

Regards,
Arivu

3

Hello! It’s not what I meant. I would like to know what maximum size of characters could enter a cell of a datatable that was extracted from a database.

For example, if “Column 1” is configured as VARCHAR(50) in the database, when it is extracted from the UiPath as data table, would this field also have a maximum capacity of 50 characters too?

Thaks!

4

Hi @emIT_User,
Use below code to get the maximum char allowed for that particular column

dt.Columns(0).MaxLength

Regards,
Arivu

2 Likes
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.