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