Statistics
| Revision:

svn-gvsig-desktop / trunk / org.gvsig.desktop / org.gvsig.desktop.plugin / org.gvsig.sqlite / org.gvsig.sqlite.provider / src / test / resources / org / gvsig / sqlite / dal / fetchFeatureType.sql @ 47579

History | View | Annotate | Download (517 Bytes)

1 

    		
  

  

    
      2
    
    
      
-- FetchFeatureType first row SQL


    		
  

  

    
      3
    
    
      
SELECT * FROM "test" LIMIT 0;


    		
  

  

    
      4
    
    
      

    		
  

  

    
      5
    
    
      
-- FetchFeatureType get primery keys SQL


    		
  

  

    
      6
    
    
      
SELECT 


    		
  

  

    
      7
    
    
      
    "COLUMN_NAME", "CONSTRAINT_TYPE" 


    		
  

  

    
      8
    
    
      
FROM INFORMATION_SCHEMA.table_constraints t_cons inner join INFORMATION_SCHEMA.key_column_usage c on c.constraint_catalog = t_cons.constraint_catalog and c.table_schema = t_cons.table_schema and c.table_name = t_cons.table_name and c.constraint_name = t_cons.constraint_name  


    		
  

  

    
      9
    
    
      
WHERE (( (c.TABLE_NAME) LIKE ('test') ) AND ( ("CONSTRAINT_TYPE") = ('PRIMARY KEY') ));