view-Name
Derby Reference Manual
21
A synonym-Name represents a synonym for a table or a view. You can qualify a
synonym-Name with a schema-Name.
Syntax
. ]
table-Name
A table-Name represents a table. You can qualify a table-Name with a schemaName.
Syntax
. ]
Example
-- SAMP.PROJECT is a table-Name that includes a schemaName
SELECT COUNT(*) FROM SAMP.PROJECT
view-Name
A view-Name represents a table or a view. You can qualify a view-Name with a
schema-Name.
Syntax
. ]
Example
-- This is a View qualified by a schema-Name
SELECT COUNT(*) FROM SAMP.EMP_RESUME
index-Name
An index-Name represents an index. Indexes live in schemas, so you can qualify their
names with schema-Names. Indexes on system tables are in the SYS schema.
Syntax
. ]
Example
DROP INDEX APP.ORIGINDEX;
-- OrigIndex is an index-Name without a schema-Name
CREATE INDEX ORIGINDEX ON FLIGHTS (ORIG_AIRPORT)
constraint-Name
You cannot qualify constraint-names.
Syntax
Example
-- country_fk2 is a constraint name
CREATE TABLE DETAILED_MAPS (COUNTRY_ISO_CODE CHAR(2)
CONSTRAINT country_fk2 REFERENCES COUNTRIES)
