官术网_书友最值得收藏!

The RENAME operation

The RENAME operation is used to alter the attribute name of the resultant relation or to give a specific name to the resultant relation. The RENAME operation is used to perform the following:

  • Remove confusion if two or more relations have attributes with the same name
  • Provide user-friendly names for attributes, especially when interfacing with reporting engines
  • Provide a convenient way to change the relation definition and still be backward compatible

The AS keyword in SQL is the equivalent of the RENAME operator in relational algebra. The following SQL example creates a relation with one tuple and one attribute, which is renamed PI:

SELECT 3.14::real AS PI;
主站蜘蛛池模板: 虎林市| 娱乐| 孝义市| 兰溪市| 黄梅县| 塔河县| 黔东| 徐闻县| 湖北省| 垫江县| 松滋市| 新竹市| 从化市| 莱西市| 孙吴县| 斗六市| 当涂县| 织金县| 玉树县| 临海市| 环江| 日照市| 广西| 五常市| 西乌| 巴林右旗| 玛沁县| 闽清县| 永顺县| 太原市| 济源市| 兴义市| 香格里拉县| 曲麻莱县| 称多县| 岗巴县| 晋宁县| 镇康县| 石渠县| 河池市| 大邑县|