Defining DB2 objects

You can use SQL statements to create, modify, and drop DB2® objects, by using various CREATE, ALTER and DROP statements.

Creation of tables
Designing tables that many applications use is a critical task. Table design can be difficult because you can represent the same information in many different ways. This information briefly describes how tables are created and altered, and how authorization is controlled.
Creation of table spaces
Often you do not need to create a table space before you create a table. You only need to create a table space explicitly when you define a declared temporary table or if you manage all of your own data sets.
Creation of indexes
Indexes provide efficient access to table data, but can require additional processing when you modify data in a table.
Creation of views
When you design your database, you might need to give users access to only certain pieces of data. You can give users controlled access by designing and using views.
Creation of large objects
Defining large objects to DB2 is different than defining other types of data and objects.
Creation of databases
When you define a DB2 database, you name an eventual collection of tables, associated indexes, and the table spaces in which they are to reside.
Creation of relationships with referential constraints
Referential integrity is a condition in which all intended references from data in one table column to data in another table column are valid. By using referential constraints, you can define relationships between entities that you define in DB2.
Creation of triggers
You can use triggers to define and enforce business rules that involve different states of the data. Triggers automatically execute a set of SQL statements whenever a specified event occurs. These statements validate and edit database changes, read and modify the database, and invoke functions that perform various operations.
Creation of user-defined functions
You can create your own functions in DB2 to simplify your queries.

Parent topic: DB2 for z/OS and SQL concepts