Infor Factory Track (SL) – Help
    • Infor Factory Track (SL) – Help
    • Software Development
    • Schema (SQL Table and Column) Editing
    • Overviews and Procedures
    • Maintaining Tables and Other SQL Schema Elements
    • Infor Factory Track (SL) – Help
      • Basics
      • Microsoft Office Integration - Application Search
      • Mongoose Administration
      • Software Development
        • Schema (SQL Table and Column) Editing
          • Overviews and Procedures
            • Maintaining Tables and Other SQL Schema Elements
              • Creating SQL Tables
              • Maintaining Columns on SQL Tables
              • Specifying Primary Keys and Other Constraints for a Table
              • Updating Existing SQL Tables
              • Editing SQL User-Defined Data Types
              • Executing SQL Statements
            • Restricted Tables
            • SQL Reserved Words
      • Developing Forms
      • Infor Factory Track
      • Infor Shop Floor
      • Infor Time Track Module
      • Infor Warehouse Mobility
      • Configuring Item Inquiry Transaction Parameters
      • Issuing and Returning Devices
      • Working with Tile Forms
      • Lunch In/Out
      • Configuring TT Time and Attendance Transaction Parameters
      • Defining the Label Formats
      • Adding Additional Fields to Barcode Labels
      • License Module Concurrent User Counts
      • Clocking Out for Lunch
      • Viewing Multi Data Barcode configuration
      • Printing Warehouse Receipt Labels
      • Configuring Work Center Status Parameters
      • Clocking In from a Break

    Maintaining Tables and Other SQL Schema Elements

    Note:  Building IDOs over tables in schemas other than dbo is not currently supported.

    See these topics to maintain tables and other SQL schema elements from the application:

    • Creating Tables
    • Maintaining Columns on Tables
    • Specifying Primary Keys and Other Constraints for a Table
    • Updating Existing Tables
    • Editing SQL User-Defined Data Types
    • Executing SQL Statements
    Related topics
    Data Type
    SQL Reserved Words
    Restricted Tables
    • Contents
    • Search
    • Contacting Infor
    • Send us your feedback about this help page
    • © Copyright 2020. Infor. All rights reserved.