Question

标识符	包	描述	注释
B012		Embedded C
B021		Direct SQL
E011	核心	Numeric data types
E011-01	核心	INTEGER and SMALLINT data types
E011-02	核心	REAL, DOUBLE PRECISION, and FLOAT data types
E011-03	核心	DECIMAL and NUMERIC data types
E011-04	核心	Arithmetic operators
E011-05	核心	Numeric comparison
E011-06	核心	Implicit casting among the numeric data types
E021	核心	Character data types
E021-01	核心	CHARACTER data type
E021-02	核心	CHARACTER VARYING data type
E021-03	核心	Character literals
E021-04	核心	CHARACTER_LENGTH function	trims trailing spaces from CHARACTER values before counting
E021-05	核心	OCTET_LENGTH function
E021-06	核心	SUBSTRING function
E021-07	核心	Character concatenation
E021-08	核心	UPPER and LOWER functions
E021-09	核心	TRIM function
E021-10	核心	Implicit casting among the character string types
E021-11	核心	POSITION function
E021-12	核心	Character comparison
E031	核心	Identifiers
E031-01	核心	Delimited identifiers
E031-02	核心	Lower case identifiers
E031-03	核心	Trailing underscore
E051	核心	Basic query specification
E051-01	核心	SELECT DISTINCT
E051-02	核心	GROUP BY clause
E051-04	核心	GROUP BY can contain columns not in <select list>
E051-05	核心	Select list items can be renamed	AS is required
E051-06	核心	HAVING clause
E051-07	核心	Qualified * in select list
E051-08	核心	Correlation names in the FROM clause
E051-09	核心	Rename columns in the FROM clause
E061	核心	Basic predicates and search conditions
E061-01	核心	Comparison predicate
E061-02	核心	BETWEEN predicate
E061-03	核心	IN predicate with list of values
E061-04	核心	LIKE predicate
E061-05	核心	LIKE predicate ESCAPE clause
E061-06	核心	NULL predicate
E061-07	核心	Quantified comparison predicate
E061-08	核心	EXISTS predicate
E061-09	核心	Subqueries in comparison predicate
E061-11	核心	Subqueries in IN predicate
E061-12	核心	Subqueries in quantified comparison predicate
E061-13	核心	Correlated subqueries
E061-14	核心	Search condition
E071	核心	Basic query expressions
E071-01	核心	UNION DISTINCT table operator
E071-02	核心	UNION ALL table operator
E071-03	核心	EXCEPT DISTINCT table operator
E071-05	核心	Columns combined via table operators need not have exactly the same data type
E071-06	核心	Table operators in subqueries
E081-01	核心	SELECT privilege
E081-02	核心	DELETE privilege
E081-03	核心	INSERT privilege at the table level
E081-04	核心	UPDATE privilege at the table level
E081-06	核心	REFERENCES privilege at the table level
E081-08	核心	WITH GRANT OPTION
E081-10	核心	EXECUTE privilege
E091	核心	Set functions
E091-01	核心	AVG
E091-02	核心	COUNT
E091-03	核心	MAX
E091-04	核心	MIN
E091-05	核心	SUM
E091-06	核心	ALL quantifier
E091-07	核心	DISTINCT quantifier
E101	核心	Basic data manipulation
E101-01	核心	INSERT statement
E101-03	核心	Searched UPDATE statement
E101-04	核心	Searched DELETE statement
E111	核心	Single row SELECT statement
E121-01	核心	DECLARE CURSOR
E121-02	核心	ORDER BY columns need not be in select list
E121-03	核心	Value expressions in ORDER BY clause
E121-04	核心	OPEN statement
E121-08	核心	CLOSE statement
E121-10	核心	FETCH statement implicit NEXT
E121-17	核心	WITH HOLD cursors
E131	核心	Null value support (nulls in lieu of values)
E141	核心	Basic integrity constraints
E141-01	核心	NOT NULL constraints
E141-02	核心	UNIQUE constraints of NOT NULL columns
E141-03	核心	PRIMARY KEY constraints
E141-04	核心	Basic FOREIGN KEY constraint with the NO ACTION default for both referential delete action and referential update action
E141-06	核心	CHECK constraints
E141-07	核心	Column defaults
E141-08	核心	NOT NULL inferred on PRIMARY KEY
E141-10	核心	Names in a foreign key can be specified in any order
E151	核心	Transaction support
E151-01	核心	COMMIT statement
E151-02	核心	ROLLBACK statement
E152	核心	Basic SET TRANSACTION statement
E152-01	核心	SET TRANSACTION statement: ISOLATION LEVEL SERIALIZABLE clause
E152-02	核心	SET TRANSACTION statement: READ ONLY and READ WRITE clauses
E161	核心	SQL comments using leading double minus
E171	核心	SQLSTATE support
F021	核心	Basic information schema
F021-01	核心	COLUMNS view
F021-02	核心	TABLES view
F021-03	核心	VIEWS view
F021-04	核心	TABLE_CONSTRAINTS view
F021-05	核心	REFERENTIAL_CONSTRAINTS view
F021-06	核心	CHECK_CONSTRAINTS view
F031	核心	Basic schema manipulation
F031-01	核心	CREATE TABLE statement to create persistent base tables
F031-02	核心	CREATE VIEW statement
F031-03	核心	GRANT statement
F031-04	核心	ALTER TABLE statement: ADD COLUMN clause
F031-13	核心	DROP TABLE statement: RESTRICT clause
F031-16	核心	DROP VIEW statement: RESTRICT clause
F031-19	核心	REVOKE statement: RESTRICT clause
F032		CASCADE drop behavior
F033		ALTER TABLE statement: DROP COLUMN clause
F034		Extended REVOKE statement
F034-01		REVOKE statement performed by other than the owner of a schema object
F034-02		REVOKE statement: GRANT OPTION FOR clause
F034-03		REVOKE statement to revoke a privilege that the grantee has WITH GRANT OPTION
F041	核心	Basic joined table
F041-01	核心	Inner join (but not necessarily the INNER keyword)
F041-02	核心	INNER keyword
F041-03	核心	LEFT OUTER JOIN
F041-04	核心	RIGHT OUTER JOIN
F041-05	核心	Outer joins can be nested
F041-07	核心	The inner table in a left or right outer join can also be used in an inner join
F041-08	核心	All comparison operators are supported (rather than just =)
F051	核心	Basic date and time
F051-01	核心	DATE data type (including support of DATE literal)
F051-02	核心	TIME data type (including support of TIME literal) with fractional seconds precision of at least 0
F051-03	核心	TIMESTAMP data type (including support of TIMESTAMP literal) with fractional seconds precision of at least 0 and 6
F051-04	核心	Comparison predicate on DATE, TIME, and TIMESTAMP data types
F051-05	核心	Explicit CAST between datetime types and character string types
F051-06	核心	CURRENT_DATE
F051-07	核心	LOCALTIME
F051-08	核心	LOCALTIMESTAMP
F052	增强日期时间设施	Intervals and datetime arithmetic
F053		OVERLAPS predicate
F081	核心	UNION and EXCEPT in views
F111		Isolation levels other than SERIALIZABLE
F111-01		READ UNCOMMITTED isolation level
F111-02		READ COMMITTED isolation level
F111-03		REPEATABLE READ isolation level
F131	核心	Grouped operations
F131-01	核心	WHERE, GROUP BY, and HAVING clauses supported in queries with grouped views
F131-02	核心	Multiple tables supported in queries with grouped views
F131-03	核心	Set functions supported in queries with grouped views
F131-04	核心	Subqueries with GROUP BY and HAVING clauses and grouped views
F131-05	核心	Single row SELECT with GROUP BY and HAVING clauses and grouped views
F171		Multiple schemas per user
F191	增强完整性管理	Referential delete actions
F201	核心	CAST function
F221	核心	Explicit defaults
F222		INSERT statement: DEFAULT VALUES clause
F231		Privilege tables
F231-01		TABLE_PRIVILEGES view
F231-02		COLUMN_PRIVILEGES view
F231-03		USAGE_PRIVILEGES view
F251		Domain support
F261	核心	CASE expression
F261-01	核心	Simple CASE
F261-02	核心	Searched CASE
F261-03	核心	NULLIF
F261-04	核心	COALESCE
F271		Compound character literals
F281		LIKE enhancements
F302		INTERSECT table operator
F302-01		INTERSECT DISTINCT table operator
F302-02		INTERSECT ALL table operator
F304		EXCEPT ALL table operator
F311-01	核心	CREATE SCHEMA
F311-02	核心	CREATE TABLE for persistent base tables
F311-03	核心	CREATE VIEW
F311-05	核心	GRANT statement
F321		User authorization
F361		Subprogram support
F381		Extended schema manipulation
F381-01		ALTER TABLE statement: ALTER COLUMN clause
F381-02		ALTER TABLE statement: ADD CONSTRAINT clause
F381-03		ALTER TABLE statement: DROP CONSTRAINT clause
F391		Long identifiers
F401		Extended joined table
F401-01		NATURAL JOIN
F401-02		FULL OUTER JOIN
F401-04		CROSS JOIN
F411	增强日期时间设施	Time zone specification	differences regarding literal interpretation
F421		National character
F431		Read-only scrollable cursors
F431-01		FETCH with explicit NEXT
F431-02		FETCH FIRST
F431-03		FETCH LAST
F431-04		FETCH PRIOR
F431-05		FETCH ABSOLUTE
F431-06		FETCH RELATIVE
F441		Extended set function support
F471	核心	Scalar subquery values
F481	核心	Expanded NULL predicate
F491	增强完整性管理	Constraint management
F501	核心	Features and conformance views
F501-01	核心	SQL_FEATURES view
F501-02	核心	SQL_SIZING view
F501-03	核心	SQL_LANGUAGES view
F502		Enhanced documentation tables
F502-01		SQL_SIZING_PROFILES view
F502-02		SQL_IMPLEMENTATION_INFO view
F502-03		SQL_PACKAGES view
F531		Temporary tables
F555	增强日期时间设施	Enhanced seconds precision
F561		Full value expressions
F571		Truth value tests
F591		Derived tables
F611		Indicator data types
F651		Catalog name qualifiers
F672		Retrospective check constraints
F701	增强完整性管理	Referential update actions
F711		ALTER domain
F761		Session management
F771		Connection management
F781		Self-referencing operations
F791		Insensitive cursors
F801		Full set function
S071	增强的对象支持	SQL paths in function and type name resolution
S111	增强的对象支持	ONLY in query expressions
S211	增强的对象支持	User-defined cast functions
T031		BOOLEAN data type
T071		BIGINT data type
T141		SIMILAR predicate
T151		DISTINCT predicate
T171		LIKE clause in table definition
T191	增强完整性管理	Referential action RESTRICT
T201	增强完整性管理	Comparable data types for referential constraints
T211-01	激活数据库，增强完整性管理	Triggers activated on UPDATE, INSERT, or DELETE of one base table
T211-02	激活数据库，增强完整性管理	BEFORE triggers
T211-03	激活数据库，增强完整性管理	AFTER triggers
T211-04	激活数据库，增强完整性管理	FOR EACH ROW triggers
T211-07	激活数据库，增强完整性管理	TRIGGER privilege
T212	增强完整性管理	Enhanced trigger capability
T231		Sensitive cursors
T241		START TRANSACTION statement
T271		Savepoints
T312		OVERLAY function
T321-01	核心	User-defined functions with no overloading
T321-03	核心	Function invocation
T321-06	核心	ROUTINES view
T321-07	核心	PARAMETERS view
T322	PSM	Overloading of SQL-invoked functions and procedures
T323		Explicit security for external routines
T351		Bracketed SQL comments (/*...*/ comments)
T441		ABS and MOD functions
T461		Symmetric BETWEEN predicate
T501		Enhanced EXISTS predicate
T551		Optional key words for default syntax
T581		Regular expression substring function
T591		UNIQUE constraints of possibly null columns