🔥🔥 Don’t Miss Out on Our End of Autumn Sale. If you have any questions, feel free to click the bottom right corner to contact our customer service..

Concat us[email protected]
Shopping Cart

No products in the cart.

🔍
BS ISO/IEC 9075-11:2023

BS ISO/IEC 9075-11:2023

$215.11

Information technology. Database languages SQL – Information and definition schemas (SQL/Schemata)

Published By Publication Date Number of Pages
BSI 2023 324
PDF Format Searchable Printable Preview Now
Guaranteed Safe Checkout
Category:

If you have any questions, feel free to reach out to our online customer service team by clicking on the bottom right corner. We’re here to assist you 24/7.
Email:[email protected]

PDF Catalog

PDF Pages PDF Title
2 undefined
5 Contents
10 Tables
11 Foreword
13 Introduction
15 1 Scope
16 2 Normative references
17 3 Terms and definitions
18 4 Concepts
4.1 Notations and conventions
4.1.1 Notations
4.1.2 Values in Descriptions
4.2 Introduction to the Definition Schema
19 4.3 Introduction to the Information Schema
21 5 Lexical elements
5.1 and
22 6 Information Schema
6.1 Information Schema digital artifact
6.2 INFORMATION_SCHEMA Schema
23 6.3 INFORMATION_SCHEMA_CATALOG_NAME view
24 6.4 CARDINAL_NUMBER domain
25 6.5 CHARACTER_DATA domain
26 6.6 SQL_IDENTIFIER domain
27 6.7 TIME_STAMP domain
28 6.8 YES_OR_NO domain
29 6.9 ADMINISTRABLE_ROLE_AUTHORIZATIONS view
30 6.10 APPLICABLE_ROLES view
31 6.11 ASSERTIONS view
32 6.12 ATTRIBUTES view
34 6.13 CHARACTER_SETS view
35 6.14 CHECK_CONSTRAINT_ROUTINE_USAGE view
36 6.15 CHECK_CONSTRAINTS view
37 6.16 COLLATIONS view
38 6.17 COLLATION_CHARACTER_SET_APPLICABILITY view
39 6.18 COLUMN_COLUMN_USAGE view
40 6.19 COLUMN_DOMAIN_USAGE view
41 6.20 COLUMN_PRIVILEGES view
42 6.21 COLUMN_UDT_USAGE view
43 6.22 COLUMNS view
46 6.23 CONSTRAINT_COLUMN_USAGE view
48 6.24 CONSTRAINT_PERIOD_USAGE view
50 6.25 CONSTRAINT_TABLE_USAGE view
51 6.26 DATA_TYPE_PRIVILEGES view
52 6.27 DIRECT_SUPERTABLES view
53 6.28 DIRECT_SUPERTYPES view
54 6.29 DOMAIN_CONSTRAINTS view
55 6.30 DOMAINS view
57 6.31 ELEMENT_TYPES view
59 6.32 ENABLED_ROLES view
60 6.33 FIELDS view
61 6.34 KEY_COLUMN_USAGE view
63 6.35 KEY_PERIOD_USAGE view
64 6.36 METHOD_SPECIFICATION_PARAMETERS view
66 6.37 METHOD_SPECIFICATIONS view
68 6.38 PARAMETERS view
70 6.39 PERIODS view
72 6.40 PRIVATE_PARAMETERS view
74 6.41 REFERENCED_TYPES view
75 6.42 REFERENTIAL_CONSTRAINTS view
76 6.43 ROLE_COLUMN_GRANTS view
77 6.44 ROLE_ROUTINE_GRANTS view
78 6.45 ROLE_TABLE_GRANTS view
79 6.46 ROLE_TABLE_METHOD_GRANTS view
80 6.47 ROLE_USAGE_GRANTS view
81 6.48 ROLE_UDT_GRANTS view
82 6.49 ROUTINE_COLUMN_USAGE view
83 6.50 ROUTINE_PERIOD_USAGE view
84 6.51 ROUTINE_PRIVILEGES view
85 6.52 ROUTINE_ROUTINE_USAGE view
86 6.53 ROUTINE_SEQUENCE_USAGE view
87 6.54 ROUTINE_TABLE_USAGE view
88 6.55 ROUTINES view
91 6.56 SCHEMATA view
92 6.57 SEQUENCES view
93 6.58 SQL_FEATURES view
94 6.59 SQL_IMPLEMENTATION_INFO view
95 6.60 SQL_PARTS view
96 6.61 SQL_SIZING view
97 6.62 TABLE_CONSTRAINTS view
98 6.63 TABLE_METHOD_PRIVILEGES view
99 6.64 TABLE_PRIVILEGES view
100 6.65 TABLES view
101 6.66 TRANSFORMS view
102 6.67 TRANSLATIONS view
103 6.68 TRIGGERED_UPDATE_COLUMNS view
104 6.69 TRIGGER_COLUMN_USAGE view
105 6.70 TRIGGER_PERIOD_USAGE view
106 6.71 TRIGGER_ROUTINE_USAGE view
107 6.72 TRIGGER_SEQUENCE_USAGE view
108 6.73 TRIGGER_TABLE_USAGE view
109 6.74 TRIGGERS view
111 6.75 UDT_PRIVILEGES view
112 6.76 USAGE_PRIVILEGES view
113 6.77 USER_DEFINED_TYPES view
115 6.78 VIEW_COLUMN_USAGE view
116 6.79 VIEW_PERIOD_USAGE view
117 6.80 VIEW_ROUTINE_USAGE view
118 6.81 VIEW_TABLE_USAGE view
119 6.82 VIEWS view
120 6.83 Short name views
140 7 Definition Schema
7.1 Definition Schema digital artifact
7.2 DEFINITION_SCHEMA Schema
141 7.3 EQUAL_KEY_DEGREES assertion
142 7.4 KEY_DEGREE_GREATER_THAN_OR_EQUAL_TO_1 assertion
143 7.5 UNIQUE_CONSTRAINT_NAME assertion
144 7.6 ASSERTIONS base table
146 7.7 ATTRIBUTES base table
148 7.8 AUTHORIZATIONS base table
149 7.9 CATALOG_NAME base table
150 7.10 CHARACTER_ENCODING_FORMS base table
152 7.11 CHARACTER_REPERTOIRES base table
154 7.12 CHARACTER_SETS base table
157 7.13 CHECK_COLUMN_USAGE base table
158 7.14 CHECK_CONSTRAINT_ROUTINE_USAGE base table
159 7.15 CHECK_CONSTRAINTS base table
160 7.16 CHECK_PERIOD_USAGE base table
161 7.17 CHECK_TABLE_USAGE base table
162 7.18 COLLATIONS base table
164 7.19 COLLATION_CHARACTER_SET_APPLICABILITY base table
166 7.20 COLUMN_COLUMN_USAGE base table
167 7.21 COLUMN_PRIVILEGES base table
169 7.22 COLUMNS base table
173 7.23 DATA_TYPE_DESCRIPTOR base table
184 7.24 DIRECT_SUPERTABLES base table
186 7.25 DIRECT_SUPERTYPES base table
188 7.26 DOMAIN_CONSTRAINTS base table
190 7.27 DOMAINS base table
191 7.28 ELEMENT_TYPES base table
193 7.29 FIELDS base table
195 7.30 KEY_COLUMN_USAGE base table
197 7.31 KEY_PERIOD_USAGE base table
199 7.32 METHOD_SPECIFICATION_PARAMETERS base table
201 7.33 METHOD_SPECIFICATIONS base table
205 7.34 PARAMETERS base table
208 7.35 PERIODS base table
209 7.36 PRIVATE_PARAMETERS base table
211 7.37 REFERENCED_TYPES base table
213 7.38 REFERENTIAL_CONSTRAINTS base table
215 7.39 ROLE_AUTHORIZATION_DESCRIPTORS base table
217 7.40 ROUTINE_COLUMN_USAGE base table
218 7.41 ROUTINE_PERIOD_USAGE base table
219 7.42 ROUTINE_PRIVILEGES base table
221 7.43 ROUTINE_ROUTINE_USAGE base table
222 7.44 ROUTINE_SEQUENCE_USAGE base table
223 7.45 ROUTINE_TABLE_USAGE base table
224 7.46 ROUTINES base table
232 7.47 SCHEMATA base table
234 7.48 SEQUENCES base table
236 7.49 SQL_CONFORMANCE base table
239 7.50 SQL_IMPLEMENTATION_INFO base table
242 7.51 SQL_SIZING base table
244 7.52 TABLE_CONSTRAINTS base table
246 7.53 TABLE_METHOD_PRIVILEGES base table
248 7.54 TABLE_PRIVILEGES base table
250 7.55 TABLES base table
253 7.56 TRANSFORMS base table
255 7.57 TRANSLATIONS base table
257 7.58 TRIGGERED_UPDATE_COLUMNS base table
258 7.59 TRIGGER_COLUMN_USAGE base table
259 7.60 TRIGGER_PERIOD_USAGE base table
260 7.61 TRIGGER_ROUTINE_USAGE base table
261 7.62 TRIGGER_SEQUENCE_USAGE base table
262 7.63 TRIGGER_TABLE_USAGE base table
263 7.64 TRIGGERS base table
266 7.65 USAGE_PRIVILEGES base table
268 7.66 USER_DEFINED_TYPE_PRIVILEGES base table
270 7.67 USER_DEFINED_TYPES base table
273 7.68 VIEW_COLUMN_USAGE base table
274 7.69 VIEW_PERIOD_USAGE base table
275 7.70 VIEW_ROUTINE_USAGE base table
276 7.71 VIEW_TABLE_USAGE base table
277 7.72 VIEWS base table
279 8 Conformance
8.1 Claims of conformance to SQL/Schemata
8.2 Additional conformance requirements for SQL/Schemata
8.3 Implied feature relationships of SQL/Schemata
280 A SQL conformance summary
306 B Implementation-defined elements
309 C Implementation-dependent elements
310 D SQL optional feature taxonomy
313 E Deprecated features
314 F Incompatibilities with ISO/IEC 9075:2016
315 G Defect Reports not addressed in this edition of this document
316 H SQL mandatory feature taxonomy
318 Index

Related products

BS ISO/IEC 9075-11:2023
$215.11