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