Infor CloudSuite Industrial Online Help
    • Infor CloudSuite Industrial Online Help
    • Software Development
    • Schema (SQL Table and Column) Editing
    • Overviews and Procedures
    • Maintaining Tables and Other SQL Schema Elements
    • Infor CloudSuite Industrial Online Help
      • About This Application
      • What's New in This Version
      • 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
      • System Administration
      • Glossary
      • Accounting and Financials
      • Customer Service
      • Procurement
      • Sales
      • EDI
      • Human Resources and Payroll
      • Configuration
      • Document Automation
      • Data Collection
      • Inventory Control and Material Planning
      • Manufacturing
      • Project Management
      • Workbenches
      • Optional Modules

    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.