Database columns and types

The Microsoft SQL Server Adapter is used with the Database Interface Designer to generate schemas for queries, tables, views, and stored procedures in a Microsoft SQL Server relational database management system (RDBMS). Item types are created in a schema that represent the data types of the columns of a query, table, view, or stored procedure.

The Database Interface Designer gets information about columns by calling Microsoft SQL Server to describe the columns associated with a query, table, view, or stored procedure. Microsoft SQL Server returns the data type, length and other information to the Database Interface Designer. The Microsoft SQL Server data types are then mapped to types in a schema.