Modifying the Table STOCK_TRADE

The STOCK_TRADE table stores real-time (intraday) trade data. You may want too modify this table to comment out the constraint statement.

  1. Locate the STOCK_TRADE table.
  2. Use double dashes to comment out the line that reads: 
    constraint PK_STOCK_TRADE primary key
(INSTRUMENT_ID, TRADE_SEQ_NBR, TRADE_DATE) on o1
    The line should now read:
    -- constraint PK_STOCK_TRADE primary key
(INSTRUMENT_ID, TRADE_SEQ_NBR, TRADE_DATE) on o1
Parent topic: Configuration Statements for Custom DDL Scripts

Created March 26, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com