Anthony Brummett > UR-0.40 > UR::DataSource::RDBMS::Table

Download:
UR-0.40.tar.gz

Dependencies

Annotate this POD

CPAN RT

New  3
Open  1
View/Report Bugs
Module Version: 0.40   Source   Latest Release: UR-0.43

NAME ^

UR::DataSource::Meta::RDBMS::Table - Object-oriented class for RDBMS table objects.

SYNOPSIS ^

  $t = UR::DataSource::Meta::RDBMS::Table->get(
                      data_source => 'Namespace::DataSource::Name',
                      table_name => 'MY_TABLE_NAME');
  @c = $t->column_names;
  @f = $t->fk_constraint_names;

DESCRIPTION ^

Objects of this class represent a table in a database. They are primarily used by the class updating logic in the command line tool ur update classes, but can be retrieved and used in any application. Their instances come from from the MetaDB (UR::DataSource::Meta) which is partitioned and has one physical database per Namespace.

Related Metadata Methods

@col_objs = $t->columns();
@col_names = $t->column_names();
@fk_objs = $t->fk_constraints();
@fk_names = $t->fk_constraint_names();
@ref_fk_objs = $t->ref_fk_constraints();
@ref_fk_names = $t->ref_fk_constraint_names();
@pk_objs = $t->primary_key_constraint_columns();
@pk_col_names = $t->primary_key_constraint_column_names();
@bi_objs = $t->bitmap_indexes();
@bi_names = $t->bitmap_index_names();

Return related metadata objects (or names) for the given table object.

syntax highlighting: