API User Tables MD / Table Name
Table Name Property


Sets or returns the name for the user defined table.

Field name: TableName.

Length: 19 characters.

Property type

Read-write property


Visual Basic
Public Property TableName() As String


When adding a user table, SAP Business One automatically adds the symbol @ as a prefix to the table name. For example, if you add a table named ABC, the resulting table name is @ABC. When referring to a user-defined table, you must use the name including the prefix @.

When adding a user table and assigning it a TableName, the DI API creates the table with an upper case name. By default, Microsoft SQL Server is not case sensitive. If it is configured to be case sensitive, make sure to specify the table name in upper-case when using the DoQuery method of the Recordset object.

See Also

Related information

Bo UTB Table Type BoUTBTableType Enumeration
Specifies the table types for user defined tables.
   Parent: User Tables MD UserTablesMD Object· Table: OUTB

User Tables MD UserTablesMD Object· Table: OUTB
The UserTablesMD object enables to manage user defined tables as follows: Add a user table. Retrieve a user table from the database by its TableName. Remove a user table. Save the object in XML format. Source table: OUTB. IMPORTANT: After...

User Table UserTable Object
The UserTable object represents records of a user-defined table.
   Parent: User Tables UserTables Collection

SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates