1 Reply Latest reply on Oct 16, 2012 9:02 AM by Ramesh Reddy

    Can I use AUTO_INCREMENT in a virtual table?

    Samier Nadji Newbie

      Hi,

       

      Can I use AUTO_INCREMENT in a virtual table?

       

      If yes what is the syntax? I tried different variations for the following but couldn't get it to work

       

      CREATE VIEW MyVirtualView (

          FirstCol                string,

          AutoIncrementCol               integer NOT NULL AUTO_INCREMENT

          )

      AS SELECT

          table1.FIRST_NAME               AS FIRST_NAME

      FROM

          MyDatasource.Table1 table1

       

      Thanks.