标准编号:ISO/IEC 9075-2:2023
中文名称:信息技术 数据库语言SQL 第2部分:基本原则(SQL/基本原则)
英文名称:Information technology — Database languages SQL — Part 2: Foundation (SQL/Foundation)
发布日期:2023-06
标准范围
ThisdocumentdefinesthedatastructuresandbasicoperationsonSQL-data.Itprovidesfunctionalcap- abilitiesforcreating,accessing,maintaining,controlling,andprotectingSQL-data. Thisdocumentspecifiesthesyntaxandsemanticsofadatabaselanguage: — forspecifyingandmodifyingthestructureandtheintegrityconstraintsofSQL-data; — fordeclaringandinvokingoperationsonSQL-dataandcursors; — fordeclaringdatabaselanguageprocedures; — forembeddingSQL-statementsinacompilationunitthatisotherwisewritteninaparticularpro- gramminglanguage(hostlanguage); — forderivinganequivalentcompilationunitinthehostlanguage.Inthatequivalentcompilation unit,eachembeddedSQL-statementhasbeenreplacedbyoneormorestatementsinthehostlan- guage,someofwhichinvokeanSQLexternally-invokedprocedurethat,whenexecuted,hasan effectequivalenttoexecutingtheSQL-statement; — fordirectinvocationofSQL-statements; — tosupportdynamicpreparationandexecutionofSQL-statements. ThisdocumentprovidesavehicleforportabilityofdatadefinitionsandcompilationunitsbetweenSQL- implementations.