The set of catalogs that can be referenced during the SQL Session is implementation d efined. The schema is created using a schema definition statement and is modified by SQL schema statements. The base table name, is explicitly or implicitly qualified by the schema name. Table A database object representing homogeneous data. An SQL2 table name can be specified by the catalog and schema names and by a name of the table itself.
Information schema A set of views that make the database self-describing.
A n extended set of schema definition statements for modifying the existing schema elements and for adding the elements to the schema at a run time. An association between SQL client and SQL server. The SQL connection identifies the SQL environment and is activated by the connect statement. The connection management statements allow you to d isconnect from the SQL environment and s et a current connection . Session A session is associated with the SQL connection.