英和和英

名詞

CTE (countable かつ uncountable, 複数形 CTEs)

1. (pathology, neurology) Initialism of chronic traumatic encephalopathy.
2. (physics) Initialism of coefficient of thermal expansion.
3. (databases, countable) Initialism of common table expression.
   • 2008, Robin Dewson, Beginning SQL Server 2008 Express for Developers, Apress, →ISBN, page 433:

     A recursive CTE is where an initial CTE is built and then the results from that are called recursively in a UNION statement returning subsets of data until all the data is returned. This gives you the ability to create data in a hierarchical fashion, as you will see in the next example.