TableSpecs contain the information Infinity needs to construct a table in SQL Server, including column, index, trigger, and constraint definitions.
Please note that with an Infinity database, tables are not created directly in SQL Server by a database administrator or a software developer using SQL Server Management Studio or Transact-SQL Data Definition Language (T-SQL DDL). Instead, TableSpecs contain all the information necessary for tables and their relationships. TableSpecs are loaded into the catalog system, which is the mechanism for adding functionality to the Infinity platform.
Before we start to create some Table Specs, let's take a little detour to explain how an Infinity application, such as Blackbaud CRM, is extended and customized…