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

🔍
BSI 22/30430213 DC:2022 Edition

BSI 22/30430213 DC:2022 Edition

$45.21

BS EN ISO/IEC 9075-11. Information technology. Database languages. SQL – Part 11. Information and definition schemas (SQL/Schemata)

Published By Publication Date Number of Pages
BSI 2022 316
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
1 30430213-NC.pdf
3 ISO_IEC DIS 9075-11 ed.5 – id.76586 Enquiry PDF (en).pdf
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
20 5 Lexical elements
5.1 and
21 6 Information Schema
6.1 Information Schema digital artifact
6.2 INFORMATION_SCHEMA Schema
22 6.3 INFORMATION_SCHEMA_CATALOG_NAME view
23 6.4 CARDINAL_NUMBER domain
24 6.5 CHARACTER_DATA domain
25 6.6 SQL_IDENTIFIER domain
26 6.7 TIME_STAMP domain
27 6.8 YES_OR_NO domain
28 6.9 ADMINISTRABLE_ROLE_AUTHORIZATIONS view
29 6.10 APPLICABLE_ROLES view
30 6.11 ASSERTIONS view
31 6.12 ATTRIBUTES view
33 6.13 CHARACTER_SETS view
34 6.14 CHECK_CONSTRAINT_ROUTINE_USAGE view
35 6.15 CHECK_CONSTRAINTS view
36 6.16 COLLATIONS view
37 6.17 COLLATION_CHARACTER_SET_APPLICABILITY view
38 6.18 COLUMN_COLUMN_USAGE view
39 6.19 COLUMN_DOMAIN_USAGE view
40 6.20 COLUMN_PRIVILEGES view
41 6.21 COLUMN_UDT_USAGE view
42 6.22 COLUMNS view
45 6.23 CONSTRAINT_COLUMN_USAGE view
47 6.24 CONSTRAINT_PERIOD_USAGE view
49 6.25 CONSTRAINT_TABLE_USAGE view
50 6.26 DATA_TYPE_PRIVILEGES view
51 6.27 DIRECT_SUPERTABLES view
52 6.28 DIRECT_SUPERTYPES view
53 6.29 DOMAIN_CONSTRAINTS view
54 6.30 DOMAINS view
56 6.31 ELEMENT_TYPES view
58 6.32 ENABLED_ROLES view
59 6.33 FIELDS view
60 6.34 KEY_COLUMN_USAGE view
62 6.35 KEY_PERIOD_USAGE view
63 6.36 METHOD_SPECIFICATION_PARAMETERS view
65 6.37 METHOD_SPECIFICATIONS view
67 6.38 PARAMETERS view
69 6.39 PERIODS view
71 6.40 PRIVATE_PARAMETERS view
73 6.41 REFERENCED_TYPES view
74 6.42 REFERENTIAL_CONSTRAINTS view
75 6.43 ROLE_COLUMN_GRANTS view
76 6.44 ROLE_ROUTINE_GRANTS view
77 6.45 ROLE_TABLE_GRANTS view
78 6.46 ROLE_TABLE_METHOD_GRANTS view
79 6.47 ROLE_USAGE_GRANTS view
80 6.48 ROLE_UDT_GRANTS view
81 6.49 ROUTINE_COLUMN_USAGE view
82 6.50 ROUTINE_PERIOD_USAGE view
83 6.51 ROUTINE_PRIVILEGES view
84 6.52 ROUTINE_ROUTINE_USAGE view
85 6.53 ROUTINE_SEQUENCE_USAGE view
86 6.54 ROUTINE_TABLE_USAGE view
87 6.55 ROUTINES view
90 6.56 SCHEMATA view
91 6.57 SEQUENCES view
92 6.58 SQL_FEATURES view
93 6.59 SQL_IMPLEMENTATION_INFO view
94 6.60 SQL_PARTS view
95 6.61 SQL_SIZING view
96 6.62 TABLE_CONSTRAINTS view
97 6.63 TABLE_METHOD_PRIVILEGES view
98 6.64 TABLE_PRIVILEGES view
99 6.65 TABLES view
100 6.66 TRANSFORMS view
101 6.67 TRANSLATIONS view
102 6.68 TRIGGERED_UPDATE_COLUMNS view
103 6.69 TRIGGER_COLUMN_USAGE view
104 6.70 TRIGGER_PERIOD_USAGE view
105 6.71 TRIGGER_ROUTINE_USAGE view
106 6.72 TRIGGER_SEQUENCE_USAGE view
107 6.73 TRIGGER_TABLE_USAGE view
108 6.74 TRIGGERS view
110 6.75 UDT_PRIVILEGES view
111 6.76 USAGE_PRIVILEGES view
112 6.77 USER_DEFINED_TYPES view
114 6.78 VIEW_COLUMN_USAGE view
115 6.79 VIEW_PERIOD_USAGE view
116 6.80 VIEW_ROUTINE_USAGE view
117 6.81 VIEW_TABLE_USAGE view
118 6.82 VIEWS view
119 6.83 Short name views
139 7 Definition Schema
7.1 Definition Schema digital artifact
7.2 DEFINITION_SCHEMA Schema
140 7.3 EQUAL_KEY_DEGREES assertion
141 7.4 KEY_DEGREE_GREATER_THAN_OR_EQUAL_TO_1 assertion
142 7.5 UNIQUE_CONSTRAINT_NAME assertion
143 7.6 ASSERTIONS base table
145 7.7 ATTRIBUTES base table
147 7.8 AUTHORIZATIONS base table
148 7.9 CATALOG_NAME base table
149 7.10 CHARACTER_ENCODING_FORMS base table
151 7.11 CHARACTER_REPERTOIRES base table
153 7.12 CHARACTER_SETS base table
156 7.13 CHECK_COLUMN_USAGE base table
157 7.14 CHECK_CONSTRAINT_ROUTINE_USAGE base table
158 7.15 CHECK_CONSTRAINTS base table
159 7.16 CHECK_PERIOD_USAGE base table
160 7.17 CHECK_TABLE_USAGE base table
161 7.18 COLLATIONS base table
163 7.19 COLLATION_CHARACTER_SET_APPLICABILITY base table
165 7.20 COLUMN_COLUMN_USAGE base table
166 7.21 COLUMN_PRIVILEGES base table
168 7.22 COLUMNS base table
172 7.23 DATA_TYPE_DESCRIPTOR base table
183 7.24 DIRECT_SUPERTABLES base table
185 7.25 DIRECT_SUPERTYPES base table
187 7.26 DOMAIN_CONSTRAINTS base table
189 7.27 DOMAINS base table
190 7.28 ELEMENT_TYPES base table
192 7.29 FIELDS base table
194 7.30 KEY_COLUMN_USAGE base table
196 7.31 KEY_PERIOD_USAGE base table
198 7.32 METHOD_SPECIFICATION_PARAMETERS base table
200 7.33 METHOD_SPECIFICATIONS base table
204 7.34 PARAMETERS base table
207 7.35 PERIODS base table
208 7.36 PRIVATE_PARAMETERS base table
210 7.37 REFERENCED_TYPES base table
212 7.38 REFERENTIAL_CONSTRAINTS base table
214 7.39 ROLE_AUTHORIZATION_DESCRIPTORS base table
216 7.40 ROUTINE_COLUMN_USAGE base table
217 7.41 ROUTINE_PERIOD_USAGE base table
218 7.42 ROUTINE_PRIVILEGES base table
220 7.43 ROUTINE_ROUTINE_USAGE base table
221 7.44 ROUTINE_SEQUENCE_USAGE base table
222 7.45 ROUTINE_TABLE_USAGE base table
223 7.46 ROUTINES base table
231 7.47 SCHEMATA base table
233 7.48 SEQUENCES base table
235 7.49 SQL_CONFORMANCE base table
238 7.50 SQL_IMPLEMENTATION_INFO base table
239 7.51 SQL_SIZING base table
240 7.52 TABLE_CONSTRAINTS base table
242 7.53 TABLE_METHOD_PRIVILEGES base table
244 7.54 TABLE_PRIVILEGES base table
246 7.55 TABLES base table
249 7.56 TRANSFORMS base table
251 7.57 TRANSLATIONS base table
253 7.58 TRIGGERED_UPDATE_COLUMNS base table
254 7.59 TRIGGER_COLUMN_USAGE base table
255 7.60 TRIGGER_PERIOD_USAGE base table
256 7.61 TRIGGER_ROUTINE_USAGE base table
257 7.62 TRIGGER_SEQUENCE_USAGE base table
258 7.63 TRIGGER_TABLE_USAGE base table
259 7.64 TRIGGERS base table
262 7.65 USAGE_PRIVILEGES base table
264 7.66 USER_DEFINED_TYPE_PRIVILEGES base table
266 7.67 USER_DEFINED_TYPES base table
269 7.68 VIEW_COLUMN_USAGE base table
270 7.69 VIEW_PERIOD_USAGE base table
271 7.70 VIEW_ROUTINE_USAGE base table
272 7.71 VIEW_TABLE_USAGE base table
273 7.72 VIEWS base table
275 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
276 A SQL Conformance Summary
302 B Implementation-defined elements
305 C Implementation-dependent elements
306 D SQL optional feature taxonomy
308 E Deprecated features
309 F Incompatibilities with ISO/IEC 9075:2016
310 G Defect reports not addressed in this edition of this document
311 H SQL mandatory feature taxonomy
313 Index

Related products

BSI 22/30430213 DC
$45.21