SQL

SQL

This chapter describes the SQL related enhancements for CA IDMS Version 18.0. These new features make it easier and faster to change the structure of an existing database and provide new options for defining SQL databases.

This section contains the following topics:

Alter and Drop Column Support

Alter Index Extensions

Alter Constraint Support

Adding a Default Index

Additional Columns in Foreign Key Indexes

Large Key Support

Improved DDL Performance