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 

    		
  

  

    
      2
    
    
      
-- FetchFeatureType first row SQL


    		
  

  

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


    		
  

  

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


    		
  

  

    
      14