Help for this page

Select Code to Download


  1. or download this
            foreach my $index_col (keys %{$schema->{"zsql:table"}->{$db_ta
    +ble}->{'zsql:index'}->{$db_index}->{'zsql:field'}} ) {
    
  2. or download this
            my @columns = keys(%{$schema->{"zsql:table"}->{$db_table}->{'z
    +sql:index'}->{$db_index}->{'zsql:field'}});
            foreach my $index_col (@columns ) {
    
  3. or download this
    Creating table TEST with statement
            create table TEST (TEST_ID INT NOT NULL, Name VARCHAR (255) NU
    +LL, ItemID VARCHAR (60) NULL, REF_ID VARCHAR (32)
    ...
    
    Adding index TEST_4TH_KEY to table TEST with
            CREATE INDEX TEST_4TH_KEY on TEST (Entry_Point, ItemID, TEST_I
    +D, REF_ID)