📄 sql_features.txt
字号:
F311 Schema definition statement 02 CREATE TABLE for persistent base tables YES F311 Schema definition statement 03 CREATE VIEW YES F311 Schema definition statement 04 CREATE VIEW: WITH CHECK OPTION NO F311 Schema definition statement 05 GRANT statement YES F312 MERGE statement NO F321 User authorization YES F341 Usage tables NO F361 Subprogram support YES F381 Extended schema manipulation YES F381 Extended schema manipulation 01 ALTER TABLE statement: ALTER COLUMN clause YES F381 Extended schema manipulation 02 ALTER TABLE statement: ADD CONSTRAINT clause YES F381 Extended schema manipulation 03 ALTER TABLE statement: DROP CONSTRAINT clause YES F391 Long identifiers YES F392 Unicode escapes in identifiers NO F393 Unicode escapes in literals NO F401 Extended joined table YES F401 Extended joined table 01 NATURAL JOIN YES F401 Extended joined table 02 FULL OUTER JOIN YES F401 Extended joined table 04 CROSS JOIN YES F402 Named column joins for LOBs, arrays, and multisets NO F411 Time zone specification YES differences regarding literal interpretationF421 National character YES F431 Read-only scrollable cursors YES F431 Read-only scrollable cursors 01 FETCH with explicit NEXT YES F431 Read-only scrollable cursors 02 FETCH FIRST YES F431 Read-only scrollable cursors 03 FETCH LAST YES F431 Read-only scrollable cursors 04 FETCH PRIOR YES F431 Read-only scrollable cursors 05 FETCH ABSOLUTE YES F431 Read-only scrollable cursors 06 FETCH RELATIVE YES F441 Extended set function support YES F442 Mixed column references in set functions NO F451 Character set definition NO F461 Named character sets NO F471 Scalar subquery values YES F481 Expanded NULL predicate YES F491 Constraint management YES F501 Features and conformance views YES F501 Features and conformance views 01 SQL_FEATURES view YES F501 Features and conformance views 02 SQL_SIZING view YES F501 Features and conformance views 03 SQL_LANGUAGES view YES F502 Enhanced documentation tables YES F502 Enhanced documentation tables 01 SQL_SIZING_PROFILES view YES F502 Enhanced documentation tables 02 SQL_IMPLEMENTATION_INFO view YES F502 Enhanced documentation tables 03 SQL_PACKAGES view YES F521 Assertions NO F531 Temporary tables YES F555 Enhanced seconds precision YES F561 Full value expressions YES F571 Truth value tests YES F591 Derived tables YES F611 Indicator data types YES F641 Row and table constructors NO F651 Catalog name qualifiers YES F661 Simple tables NO F671 Subqueries in CHECK NO intentionally omittedF672 Retrospective check constraints YES F691 Collation and translation NO F692 Enhanced collation support NO F693 SQL-session and client module collations NO F695 Translation support NO F696 Additional translation documentation NO F701 Referential update actions YES F711 ALTER domain YES F721 Deferrable constraints NO foreign keys onlyF731 INSERT column privileges NO F741 Referential MATCH types NO no partial match yetF751 View CHECK enhancements NO F761 Session management YES F771 Connection management YES F781 Self-referencing operations YES F791 Insensitive cursors YES F801 Full set function YES F811 Extended flagging NO F812 Basic flagging NO F813 Extended flagging NO F821 Local table references NO F831 Full cursor update NO F831 Full cursor update 01 Updatable scrollable cursors NO F831 Full cursor update 02 Updatable ordered cursors NO S011 Distinct data types NO S011 Distinct data types 01 USER_DEFINED_TYPES view NO S023 Basic structured types NO S024 Enhanced structured types NO S025 Final structured types NO S026 Self-referencing structured types NO S027 Create method by specific method name NO S028 Permutable UDT options list NO S041 Basic reference types NO S043 Enhanced reference types NO S051 Create table of type NO S071 SQL paths in function and type name resolution YES S081 Subtables NO S091 Basic array support NO S091 Basic array support 01 Arrays of built-in data types NO S091 Basic array support 02 Arrays of distinct types NO S091 Basic array support 03 Array expressions NO S092 Arrays of user-defined types NO S094 Arrays of reference types NO S095 Array constructors by query NO S096 Optional array bounds NO S097 Array element assignment NO S111 ONLY in query expressions YES S151 Type predicate NO S161 Subtype treatment NO S162 Subtype treatment for references NO S201 SQL-invoked routines on arrays NO S201 SQL-invoked routines on arrays 01 Array parameters NO S201 SQL-invoked routines on arrays 02 Array as result type of functions NO S202 SQL-invoked routines on multisets NO S211 User-defined cast functions YES S231 Structured type locators NO S232 Array locators NO S233 Multiset locators NO S241 Transform functions NO S242 Alter transform statement NO S251 User-defined orderings NO S261 Specific type method NO S271 Basic multiset support NO S272 Multisets of user-defined types NO S274 Multisets of reference types NO S275 Advanced multiset support NO S281 Nested collection types NO S291 Unique constraint on entire row NO T011 Timestamp in Information Schema NO T031 BOOLEAN data type YES T041 Basic LOB data type support NO T041 Basic LOB data type support 01 BLOB data type NO T041 Basic LOB data type support 02 CLOB data type NO T041 Basic LOB data type support 03 POSITION, LENGTH, LOWER, TRIM, UPPER, and SUBSTRING functions for LOB data types NO T041 Basic LOB data type support 04 Concatenation of LOB data types NO T041 Basic LOB data type support 05 LOB locator: non-holdable NO T042 Extended LOB data type support NO T051 Row types NO T052 MAX and MIN for row types NO T053 Explicit aliases for all-fields reference NO T061 UCS support NO T071 BIGINT data type YES T111 Updatable joins, unions, and columns NO T121 WITH (excluding RECURSIVE) in query expression NO T122 WITH (excluding RECURSIVE) in subquery NO T131 Recursive query NO T132 Recursive query in subquery NO T141 SIMILAR predicate YES T151 DISTINCT predicate YES T152 DISTINCT predicate with negation NO T171 LIKE clause in table definition YES T172 AS subquery clause in table definition NO T173 Extended LIKE clause in table definition NO T174 Identity columns NO T175 Generated columns NO T176 Sequence generator support NO T191 Referential action RESTRICT YES T201 Comparable data types for referential constraints YES T211 Basic trigger capability NO T211 Basic trigger capability 01 Triggers activated on UPDATE, INSERT, or DELETE of one base table YES T211 Basic trigger capability 02 BEFORE triggers YES T211 Basic trigger capability 03 AFTER triggers YES T211 Basic trigger capability 04 FOR EACH ROW triggers YES T211 Basic trigger capability 05 Ability to specify a search condition that must be true before the trigger is invoked NO T211 Basic trigger capability 06 Support for run-time rules for the interaction of triggers and constraints NO T211 Basic trigger capability 07 TRIGGER privilege YES T211 Basic trigger capability 08 Multiple triggers for the same event are executed in the order in which they were created in the catalog NO intentionally omittedT212 Enhanced trigger capability YES T231 Sensitive cursors YES T241 START TRANSACTION statement YES T251 SET TRANSACTION statement: LOCAL option NO T261 Chained transactions NO T271 Savepoints YES T272 Enhanced savepoint management NO T281 SELECT privilege with column granularity NO T301 Functional dependencies NO T312 OVERLAY function YES T321 Basic SQL-invoked routines NO T321 Basic SQL-invoked routines 01 User-defined functions with no overloading YES T321 Basic SQL-invoked routines 02 User-defined stored procedures with no overloading NO T321 Basic SQL-invoked routines 03 Function invocation YES T321 Basic SQL-invoked routines 04 CALL statement NO T321 Basic SQL-invoked routines 05 RETURN statement NO T321 Basic SQL-invoked routines 06 ROUTINES view YES T321 Basic SQL-invoked routines 07 PARAMETERS view YES T322 Overloading of SQL-invoked functions and procedures YES T323 Explicit security for external routines YES T324 Explicit security for SQL routines NO T325 Qualified SQL parameter references NO T326 Table functions NO T331 Basic roles NO T332 Extended roles NO T351 Bracketed SQL comments (/*...*/ comments) YES T401 INSERT into a cursor NO T411 UPDATE statement: SET ROW option NO T431 Extended grouping capabilities NO T432 Nested and concatenated GROUPING SETS NO T433 Multiargument GROUPING function NO T434 GROUP BY DISINCT NO T441 ABS and MOD functions YES T461 Symmetric BETWEEN predicate YES T471 Result sets return value NO T491 LATERAL derived table NO T501 Enhanced EXISTS predicate YES T511 Transaction counts NO T541 Updatable table references NO T551 Optional key words for default syntax YES T561 Holdable locators NO T571 Array-returning external SQL-invoked functions NO T572 Multiset-returning external SQL-invoked functions NO T581 Regular expression substring function YES T591 UNIQUE constraints of possibly null columns YES T601 Local cursor references NO T611 Elementary OLAP operations NO T612 Advanced OLAP operations NO T613 Sampling NO T621 Enhanced numeric functions NO T631 IN predicate with one list element NO T641 Multiple column assignment NO T651 SQL-schema statements in SQL routines NO T652 SQL-dynamic statements in SQL routines NO T653 SQL-schema statements in external routines NO T654 SQL-dynamic statements in external routines NO T655 Cyclically dependent routines NO ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -