Statistics
| Revision:

svn-gvsig-desktop / trunk / org.gvsig.desktop / org.gvsig.desktop.plugin / org.gvsig.h2spatial / org.gvsig.h2spatial.h2gis132 / org.gvsig.h2spatial.h2gis132.provider / src / test / resources / org / gvsig / fmap / dal / store / h2 / fetchFeatureType.sql @ 46277

History | View | Annotate | Download (362 Bytes)

1 45472 jjdelcerro 

      

      

        2
        
        
        
        
        
-- FetchFeatureType first row SQL


      

      

        3
        
            46277
        
        
            jjdelcerro
        
        
SELECT * FROM "PUBLIC"."test" LIMIT 0;


      

      

        4
        
            45472
        
        
            jjdelcerro
        
        

      

      

        5
        
        
        
        
        
-- FetchFeatureType get primery keys SQL


      

      

        6
        
        
        
        
        
 SELECT


      

      

        7
        
        
        
        
        
  "COLUMN_LIST", "CONSTRAINT_TYPE"


      

      

        8
        
        
        
        
        
  FROM "INFORMATION_SCHEMA"."CONSTRAINTS"


      

      

        9
        
        
        
        
        
  WHERE


      

      

        10
        
        
        
        
        
    ((( ("TABLE_NAME") LIKE ('test') ) AND


      

      

        11
        
        
        
        
        
      ( ("TABLE_SCHEMA") LIKE ('PUBLIC') )) AND


      

      

        12
        
        
        
        
        
      ( ("CONSTRAINT_TYPE") = ('PRIMARY KEY') )


      

      

        13
        
        
        
        
        
    );