mmodbc.ini File for ODBC MS SQL Database Access

This topic contains the placeholders' system names in statements, used by ODBC access to MS SQL Server.

Below are the placeholders' system names in statements, that are used by ODBC access to MS SQL Server:

  • ALL_TABLES=sysobjects
  • TABLE_NAME=name
  • ALL_INDEXES=sysindexes
  • INDEX_NAME=name
  • ALL_SEQUENCES=none
  • SEQUENCE_NAME=none
  • SEQUENCES=FALSE
  • PROCEDURES=TRUE
  • FIXCHAR= CHAR( %d)
  • VARCHAR= VARCHAR( %d)
  • SMALLINT=INTEGER
  • INTEGER=INTEGER
  • FLOAT=FLOAT
  • DOUBLE=FLOAT
  • BINARY= BINARY( %d)
  • VARBINARY= VARBINARY( %d)
  • TEXT=TEXT
  • IMAGE=IMAGE
  • ID=INTEGER
  • MAXVARLEN=255