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

View differences:

fetchFeatureType.sql
1 1 

  		




  2
  2
  
    
-- FetchFeatureType first row SQL


  		




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


  		




  
  3
  
    
SELECT * FROM "test" LIMIT 0;


  		




  4
  4
  
    

  		




  5
  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
  
  
    

  		




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


  		












Also available in:  Unified diff