Modifying the Table STOCK_QUOTE

The STOCK_QUOTE table stores real-time (intraday) quotes. You may also want to modify this table to comment out the constraint statement.

  1. Locate the STOCK_QUOTE table.
  2. Use double dashes to comment out the line that reads: 
    constraint PK_STOCK_QUOTE primary key
(INSTRUMENT_ID, QUOTE_DATE, QUOTE_SEQ_NBR) on o1
    The line should now read:
    -- constraint PK_STOCK_QUOTE primary key
(INSTRUMENT_ID, QUOTE_DATE, QUOTE_SEQ_NBR) 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