{"id":434432,"date":"2024-10-20T07:44:03","date_gmt":"2024-10-20T07:44:03","guid":{"rendered":"https:\/\/pdfstandards.shop\/product\/uncategorized\/bs-iso-iec-9075-112023\/"},"modified":"2024-10-26T14:40:36","modified_gmt":"2024-10-26T14:40:36","slug":"bs-iso-iec-9075-112023","status":"publish","type":"product","link":"https:\/\/pdfstandards.shop\/product\/publishers\/bsi\/bs-iso-iec-9075-112023\/","title":{"rendered":"BS ISO\/IEC 9075-11:2023"},"content":{"rendered":"

PDF Catalog<\/h4>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
PDF Pages<\/th>\nPDF Title<\/th>\n<\/tr>\n
2<\/td>\nundefined <\/td>\n<\/tr>\n
5<\/td>\nContents <\/td>\n<\/tr>\n
10<\/td>\nTables <\/td>\n<\/tr>\n
11<\/td>\nForeword <\/td>\n<\/tr>\n
13<\/td>\nIntroduction <\/td>\n<\/tr>\n
15<\/td>\n1 Scope <\/td>\n<\/tr>\n
16<\/td>\n2 Normative references <\/td>\n<\/tr>\n
17<\/td>\n3 Terms and definitions <\/td>\n<\/tr>\n
18<\/td>\n4 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>\n4.3 Introduction to the Information Schema <\/td>\n<\/tr>\n
21<\/td>\n5 Lexical elements
5.1 and <\/td>\n<\/tr>\n
22<\/td>\n6 Information Schema
6.1 Information Schema digital artifact
6.2 INFORMATION_SCHEMA Schema <\/td>\n<\/tr>\n
23<\/td>\n6.3 INFORMATION_SCHEMA_CATALOG_NAME view <\/td>\n<\/tr>\n
24<\/td>\n6.4 CARDINAL_NUMBER domain <\/td>\n<\/tr>\n
25<\/td>\n6.5 CHARACTER_DATA domain <\/td>\n<\/tr>\n
26<\/td>\n6.6 SQL_IDENTIFIER domain <\/td>\n<\/tr>\n
27<\/td>\n6.7 TIME_STAMP domain <\/td>\n<\/tr>\n
28<\/td>\n6.8 YES_OR_NO domain <\/td>\n<\/tr>\n
29<\/td>\n6.9 ADMINISTRABLE_ROLE_AUTHORIZATIONS view <\/td>\n<\/tr>\n
30<\/td>\n6.10 APPLICABLE_ROLES view <\/td>\n<\/tr>\n
31<\/td>\n6.11 ASSERTIONS view <\/td>\n<\/tr>\n
32<\/td>\n6.12 ATTRIBUTES view <\/td>\n<\/tr>\n
34<\/td>\n6.13 CHARACTER_SETS view <\/td>\n<\/tr>\n
35<\/td>\n6.14 CHECK_CONSTRAINT_ROUTINE_USAGE view <\/td>\n<\/tr>\n
36<\/td>\n6.15 CHECK_CONSTRAINTS view <\/td>\n<\/tr>\n
37<\/td>\n6.16 COLLATIONS view <\/td>\n<\/tr>\n
38<\/td>\n6.17 COLLATION_CHARACTER_SET_APPLICABILITY view <\/td>\n<\/tr>\n
39<\/td>\n6.18 COLUMN_COLUMN_USAGE view <\/td>\n<\/tr>\n
40<\/td>\n6.19 COLUMN_DOMAIN_USAGE view <\/td>\n<\/tr>\n
41<\/td>\n6.20 COLUMN_PRIVILEGES view <\/td>\n<\/tr>\n
42<\/td>\n6.21 COLUMN_UDT_USAGE view <\/td>\n<\/tr>\n
43<\/td>\n6.22 COLUMNS view <\/td>\n<\/tr>\n
46<\/td>\n6.23 CONSTRAINT_COLUMN_USAGE view <\/td>\n<\/tr>\n
48<\/td>\n6.24 CONSTRAINT_PERIOD_USAGE view <\/td>\n<\/tr>\n
50<\/td>\n6.25 CONSTRAINT_TABLE_USAGE view <\/td>\n<\/tr>\n
51<\/td>\n6.26 DATA_TYPE_PRIVILEGES view <\/td>\n<\/tr>\n
52<\/td>\n6.27 DIRECT_SUPERTABLES view <\/td>\n<\/tr>\n
53<\/td>\n6.28 DIRECT_SUPERTYPES view <\/td>\n<\/tr>\n
54<\/td>\n6.29 DOMAIN_CONSTRAINTS view <\/td>\n<\/tr>\n
55<\/td>\n6.30 DOMAINS view <\/td>\n<\/tr>\n
57<\/td>\n6.31 ELEMENT_TYPES view <\/td>\n<\/tr>\n
59<\/td>\n6.32 ENABLED_ROLES view <\/td>\n<\/tr>\n
60<\/td>\n6.33 FIELDS view <\/td>\n<\/tr>\n
61<\/td>\n6.34 KEY_COLUMN_USAGE view <\/td>\n<\/tr>\n
63<\/td>\n6.35 KEY_PERIOD_USAGE view <\/td>\n<\/tr>\n
64<\/td>\n6.36 METHOD_SPECIFICATION_PARAMETERS view <\/td>\n<\/tr>\n
66<\/td>\n6.37 METHOD_SPECIFICATIONS view <\/td>\n<\/tr>\n
68<\/td>\n6.38 PARAMETERS view <\/td>\n<\/tr>\n
70<\/td>\n6.39 PERIODS view <\/td>\n<\/tr>\n
72<\/td>\n6.40 PRIVATE_PARAMETERS view <\/td>\n<\/tr>\n
74<\/td>\n6.41 REFERENCED_TYPES view <\/td>\n<\/tr>\n
75<\/td>\n6.42 REFERENTIAL_CONSTRAINTS view <\/td>\n<\/tr>\n
76<\/td>\n6.43 ROLE_COLUMN_GRANTS view <\/td>\n<\/tr>\n
77<\/td>\n6.44 ROLE_ROUTINE_GRANTS view <\/td>\n<\/tr>\n
78<\/td>\n6.45 ROLE_TABLE_GRANTS view <\/td>\n<\/tr>\n
79<\/td>\n6.46 ROLE_TABLE_METHOD_GRANTS view <\/td>\n<\/tr>\n
80<\/td>\n6.47 ROLE_USAGE_GRANTS view <\/td>\n<\/tr>\n
81<\/td>\n6.48 ROLE_UDT_GRANTS view <\/td>\n<\/tr>\n
82<\/td>\n6.49 ROUTINE_COLUMN_USAGE view <\/td>\n<\/tr>\n
83<\/td>\n6.50 ROUTINE_PERIOD_USAGE view <\/td>\n<\/tr>\n
84<\/td>\n6.51 ROUTINE_PRIVILEGES view <\/td>\n<\/tr>\n
85<\/td>\n6.52 ROUTINE_ROUTINE_USAGE view <\/td>\n<\/tr>\n
86<\/td>\n6.53 ROUTINE_SEQUENCE_USAGE view <\/td>\n<\/tr>\n
87<\/td>\n6.54 ROUTINE_TABLE_USAGE view <\/td>\n<\/tr>\n
88<\/td>\n6.55 ROUTINES view <\/td>\n<\/tr>\n
91<\/td>\n6.56 SCHEMATA view <\/td>\n<\/tr>\n
92<\/td>\n6.57 SEQUENCES view <\/td>\n<\/tr>\n
93<\/td>\n6.58 SQL_FEATURES view <\/td>\n<\/tr>\n
94<\/td>\n6.59 SQL_IMPLEMENTATION_INFO view <\/td>\n<\/tr>\n
95<\/td>\n6.60 SQL_PARTS view <\/td>\n<\/tr>\n
96<\/td>\n6.61 SQL_SIZING view <\/td>\n<\/tr>\n
97<\/td>\n6.62 TABLE_CONSTRAINTS view <\/td>\n<\/tr>\n
98<\/td>\n6.63 TABLE_METHOD_PRIVILEGES view <\/td>\n<\/tr>\n
99<\/td>\n6.64 TABLE_PRIVILEGES view <\/td>\n<\/tr>\n
100<\/td>\n6.65 TABLES view <\/td>\n<\/tr>\n
101<\/td>\n6.66 TRANSFORMS view <\/td>\n<\/tr>\n
102<\/td>\n6.67 TRANSLATIONS view <\/td>\n<\/tr>\n
103<\/td>\n6.68 TRIGGERED_UPDATE_COLUMNS view <\/td>\n<\/tr>\n
104<\/td>\n6.69 TRIGGER_COLUMN_USAGE view <\/td>\n<\/tr>\n
105<\/td>\n6.70 TRIGGER_PERIOD_USAGE view <\/td>\n<\/tr>\n
106<\/td>\n6.71 TRIGGER_ROUTINE_USAGE view <\/td>\n<\/tr>\n
107<\/td>\n6.72 TRIGGER_SEQUENCE_USAGE view <\/td>\n<\/tr>\n
108<\/td>\n6.73 TRIGGER_TABLE_USAGE view <\/td>\n<\/tr>\n
109<\/td>\n6.74 TRIGGERS view <\/td>\n<\/tr>\n
111<\/td>\n6.75 UDT_PRIVILEGES view <\/td>\n<\/tr>\n
112<\/td>\n6.76 USAGE_PRIVILEGES view <\/td>\n<\/tr>\n
113<\/td>\n6.77 USER_DEFINED_TYPES view <\/td>\n<\/tr>\n
115<\/td>\n6.78 VIEW_COLUMN_USAGE view <\/td>\n<\/tr>\n
116<\/td>\n6.79 VIEW_PERIOD_USAGE view <\/td>\n<\/tr>\n
117<\/td>\n6.80 VIEW_ROUTINE_USAGE view <\/td>\n<\/tr>\n
118<\/td>\n6.81 VIEW_TABLE_USAGE view <\/td>\n<\/tr>\n
119<\/td>\n6.82 VIEWS view <\/td>\n<\/tr>\n
120<\/td>\n6.83 Short name views <\/td>\n<\/tr>\n
140<\/td>\n7 Definition Schema
7.1 Definition Schema digital artifact
7.2 DEFINITION_SCHEMA Schema <\/td>\n<\/tr>\n
141<\/td>\n7.3 EQUAL_KEY_DEGREES assertion <\/td>\n<\/tr>\n
142<\/td>\n7.4 KEY_DEGREE_GREATER_THAN_OR_EQUAL_TO_1 assertion <\/td>\n<\/tr>\n
143<\/td>\n7.5 UNIQUE_CONSTRAINT_NAME assertion <\/td>\n<\/tr>\n
144<\/td>\n7.6 ASSERTIONS base table <\/td>\n<\/tr>\n
146<\/td>\n7.7 ATTRIBUTES base table <\/td>\n<\/tr>\n
148<\/td>\n7.8 AUTHORIZATIONS base table <\/td>\n<\/tr>\n
149<\/td>\n7.9 CATALOG_NAME base table <\/td>\n<\/tr>\n
150<\/td>\n7.10 CHARACTER_ENCODING_FORMS base table <\/td>\n<\/tr>\n
152<\/td>\n7.11 CHARACTER_REPERTOIRES base table <\/td>\n<\/tr>\n
154<\/td>\n7.12 CHARACTER_SETS base table <\/td>\n<\/tr>\n
157<\/td>\n7.13 CHECK_COLUMN_USAGE base table <\/td>\n<\/tr>\n
158<\/td>\n7.14 CHECK_CONSTRAINT_ROUTINE_USAGE base table <\/td>\n<\/tr>\n
159<\/td>\n7.15 CHECK_CONSTRAINTS base table <\/td>\n<\/tr>\n
160<\/td>\n7.16 CHECK_PERIOD_USAGE base table <\/td>\n<\/tr>\n
161<\/td>\n7.17 CHECK_TABLE_USAGE base table <\/td>\n<\/tr>\n
162<\/td>\n7.18 COLLATIONS base table <\/td>\n<\/tr>\n
164<\/td>\n7.19 COLLATION_CHARACTER_SET_APPLICABILITY base table <\/td>\n<\/tr>\n
166<\/td>\n7.20 COLUMN_COLUMN_USAGE base table <\/td>\n<\/tr>\n
167<\/td>\n7.21 COLUMN_PRIVILEGES base table <\/td>\n<\/tr>\n
169<\/td>\n7.22 COLUMNS base table <\/td>\n<\/tr>\n
173<\/td>\n7.23 DATA_TYPE_DESCRIPTOR base table <\/td>\n<\/tr>\n
184<\/td>\n7.24 DIRECT_SUPERTABLES base table <\/td>\n<\/tr>\n
186<\/td>\n7.25 DIRECT_SUPERTYPES base table <\/td>\n<\/tr>\n
188<\/td>\n7.26 DOMAIN_CONSTRAINTS base table <\/td>\n<\/tr>\n
190<\/td>\n7.27 DOMAINS base table <\/td>\n<\/tr>\n
191<\/td>\n7.28 ELEMENT_TYPES base table <\/td>\n<\/tr>\n
193<\/td>\n7.29 FIELDS base table <\/td>\n<\/tr>\n
195<\/td>\n7.30 KEY_COLUMN_USAGE base table <\/td>\n<\/tr>\n
197<\/td>\n7.31 KEY_PERIOD_USAGE base table <\/td>\n<\/tr>\n
199<\/td>\n7.32 METHOD_SPECIFICATION_PARAMETERS base table <\/td>\n<\/tr>\n
201<\/td>\n7.33 METHOD_SPECIFICATIONS base table <\/td>\n<\/tr>\n
205<\/td>\n7.34 PARAMETERS base table <\/td>\n<\/tr>\n
208<\/td>\n7.35 PERIODS base table <\/td>\n<\/tr>\n
209<\/td>\n7.36 PRIVATE_PARAMETERS base table <\/td>\n<\/tr>\n
211<\/td>\n7.37 REFERENCED_TYPES base table <\/td>\n<\/tr>\n
213<\/td>\n7.38 REFERENTIAL_CONSTRAINTS base table <\/td>\n<\/tr>\n
215<\/td>\n7.39 ROLE_AUTHORIZATION_DESCRIPTORS base table <\/td>\n<\/tr>\n
217<\/td>\n7.40 ROUTINE_COLUMN_USAGE base table <\/td>\n<\/tr>\n
218<\/td>\n7.41 ROUTINE_PERIOD_USAGE base table <\/td>\n<\/tr>\n
219<\/td>\n7.42 ROUTINE_PRIVILEGES base table <\/td>\n<\/tr>\n
221<\/td>\n7.43 ROUTINE_ROUTINE_USAGE base table <\/td>\n<\/tr>\n
222<\/td>\n7.44 ROUTINE_SEQUENCE_USAGE base table <\/td>\n<\/tr>\n
223<\/td>\n7.45 ROUTINE_TABLE_USAGE base table <\/td>\n<\/tr>\n
224<\/td>\n7.46 ROUTINES base table <\/td>\n<\/tr>\n
232<\/td>\n7.47 SCHEMATA base table <\/td>\n<\/tr>\n
234<\/td>\n7.48 SEQUENCES base table <\/td>\n<\/tr>\n
236<\/td>\n7.49 SQL_CONFORMANCE base table <\/td>\n<\/tr>\n
239<\/td>\n7.50 SQL_IMPLEMENTATION_INFO base table <\/td>\n<\/tr>\n
242<\/td>\n7.51 SQL_SIZING base table <\/td>\n<\/tr>\n
244<\/td>\n7.52 TABLE_CONSTRAINTS base table <\/td>\n<\/tr>\n
246<\/td>\n7.53 TABLE_METHOD_PRIVILEGES base table <\/td>\n<\/tr>\n
248<\/td>\n7.54 TABLE_PRIVILEGES base table <\/td>\n<\/tr>\n
250<\/td>\n7.55 TABLES base table <\/td>\n<\/tr>\n
253<\/td>\n7.56 TRANSFORMS base table <\/td>\n<\/tr>\n
255<\/td>\n7.57 TRANSLATIONS base table <\/td>\n<\/tr>\n
257<\/td>\n7.58 TRIGGERED_UPDATE_COLUMNS base table <\/td>\n<\/tr>\n
258<\/td>\n7.59 TRIGGER_COLUMN_USAGE base table <\/td>\n<\/tr>\n
259<\/td>\n7.60 TRIGGER_PERIOD_USAGE base table <\/td>\n<\/tr>\n
260<\/td>\n7.61 TRIGGER_ROUTINE_USAGE base table <\/td>\n<\/tr>\n
261<\/td>\n7.62 TRIGGER_SEQUENCE_USAGE base table <\/td>\n<\/tr>\n
262<\/td>\n7.63 TRIGGER_TABLE_USAGE base table <\/td>\n<\/tr>\n
263<\/td>\n7.64 TRIGGERS base table <\/td>\n<\/tr>\n
266<\/td>\n7.65 USAGE_PRIVILEGES base table <\/td>\n<\/tr>\n
268<\/td>\n7.66 USER_DEFINED_TYPE_PRIVILEGES base table <\/td>\n<\/tr>\n
270<\/td>\n7.67 USER_DEFINED_TYPES base table <\/td>\n<\/tr>\n
273<\/td>\n7.68 VIEW_COLUMN_USAGE base table <\/td>\n<\/tr>\n
274<\/td>\n7.69 VIEW_PERIOD_USAGE base table <\/td>\n<\/tr>\n
275<\/td>\n7.70 VIEW_ROUTINE_USAGE base table <\/td>\n<\/tr>\n
276<\/td>\n7.71 VIEW_TABLE_USAGE base table <\/td>\n<\/tr>\n
277<\/td>\n7.72 VIEWS base table <\/td>\n<\/tr>\n
279<\/td>\n8 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
280<\/td>\nA SQL conformance summary <\/td>\n<\/tr>\n
306<\/td>\nB Implementation-defined elements <\/td>\n<\/tr>\n
309<\/td>\nC Implementation-dependent elements <\/td>\n<\/tr>\n
310<\/td>\nD SQL optional feature taxonomy <\/td>\n<\/tr>\n
313<\/td>\nE Deprecated features <\/td>\n<\/tr>\n
314<\/td>\nF Incompatibilities with ISO\/IEC 9075:2016 <\/td>\n<\/tr>\n
315<\/td>\nG Defect Reports not addressed in this edition of this document <\/td>\n<\/tr>\n
316<\/td>\nH SQL mandatory feature taxonomy <\/td>\n<\/tr>\n
318<\/td>\nIndex <\/td>\n<\/tr>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

Information technology. Database languages SQL – Information and definition schemas (SQL\/Schemata)<\/b><\/p>\n\n\n\n\n
Published By<\/td>\nPublication Date<\/td>\nNumber of Pages<\/td>\n<\/tr>\n
BSI<\/b><\/a><\/td>\n2023<\/td>\n324<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"featured_media":434442,"template":"","meta":{"rank_math_lock_modified_date":false,"ep_exclude_from_search":false},"product_cat":[2641],"product_tag":[],"class_list":{"0":"post-434432","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-bsi","8":"first","9":"instock","10":"sold-individually","11":"shipping-taxable","12":"purchasable","13":"product-type-simple"},"_links":{"self":[{"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product\/434432","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/types\/product"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/media\/434442"}],"wp:attachment":[{"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/media?parent=434432"}],"wp:term":[{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product_cat?post=434432"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product_tag?post=434432"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}