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

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;
主站蜘蛛池模板: 高陵县| 桃园市| 康马县| 乌兰察布市| 浦县| 镇江市| 通化县| 渭南市| 彭泽县| 新平| 江西省| 禄劝| 阿尔山市| 霸州市| 金阳县| 三河市| 涡阳县| 怀安县| 鱼台县| 清涧县| 康保县| 北票市| 来宾市| 秦安县| 桃园市| 阿勒泰市| 东山县| 伊宁市| 宝鸡市| 潞西市| 西宁市| 萨嘎县| 沂南县| 吉安市| 南平市| 晋州市| 兴和县| 大名县| 革吉县| 婺源县| 乾安县|