Skip to main content

Get table information

Gets information about the table

Function GetTableInformation(Val Table, Val Connection = "", Val Tls = "") Export

ParameterCLI optionTypeRequiredDescription
Table--tableStringTable name
Connection--dbcString, ArbitraryConnection or connection string
Tls--tlsStructure Of KeyAndValueTLS settings, if necessary. See GetTlsSettings

Returns: Map Of KeyAndValue - Result of query execution


1C:Enterprise/OneScript code example
    Address  = "127.0.0.1";
Login = "bayselonarrend";
Password = "12we...";
Base = "testbase1";

ConnectionString = OPI_MySQL.GenerateConnectionString(Address, Base, Login, Password);

Table = "testtable";

// When using the connection string, a new connection is initialised,
// which will be closed after the function is executed.
// If several operations are performed, it is desirable to use one connection,
// previously created by the CreateConnection function()
Result = OPI_MySQL.GetTableInformation(Table, ConnectionString);
    oint mysql GetTableInformation \
--table "heyho" \
--dbc "mysql://bayselonarrend:***@127.0.0.1:3306/"