Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA Enterprise SCADA

Microsoft SQL Engine default schema

  • Last UpdatedApr 24, 2025
  • 1 minute read

The Microsoft SQL Engine default schema is in Native format. The Microsoft SQL Engine provides Microsoft SQL access to the data through queries like the following:

select "iengr.egumin" from analog where name = 'Analog_1';

The Microsoft SQL Engine understands that iengr.egumin is the name of a single field or column of data, despite the fact that it includes an embedded dot character. The Microsoft SQL command uses double-quote characters to delimit illegal Microsoft SQL characters within an identifier such as a column name. The Microsoft SQL command also uses double-quote characters to delimit reserved words so they can be used as identifiers; for example, "group".