Statistics
| Revision:

svn-gvsig-desktop / trunk / org.gvsig.desktop / org.gvsig.desktop.compat.cdc / org.gvsig.fmap.dal / org.gvsig.fmap.dal.db / org.gvsig.fmap.dal.db.h2 / src / test / resources / org / gvsig / fmap / dal / store / h2 / fetchFeatureType.sql @ 44678

History | View | Annotate | Download (362 Bytes)

1 44678 jjdelcerro 

      

      

        2
        
        
        
        
        
-- FetchFeatureType first row SQL


      

      

        3
        
        
        
        
        
SELECT * FROM "PUBLIC"."test" LIMIT 1;


      

      

        4
        
        
        
        
        

      

      

        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
        
        
        
        
        
    );