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.mdb / src / test / resources / org / gvsig / fmap / dal / store / mdb / fetchFeatureType.sql @ 44916

History | View | Annotate | Download (362 Bytes)

1 

    		
  

  

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


    		
  

  

    
      14