Skip to content

Commit 1e4a9ec

Browse files
committed
Replicated table
Changed details on where replicated tables are stored.
1 parent a3a8f7f commit 1e4a9ec

1 file changed

Lines changed: 2 additions & 2 deletions

File tree

docs/t-sql/statements/create-table-azure-sql-data-warehouse.md

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11
---
22
title: "CREATE TABLE (Azure SQL Data Warehouse) | Microsoft Docs"
33
ms.custom: ""
4-
ms.date: "06/12/2017"
4+
ms.date: "07/14/2017"
55
ms.prod: "sql-non-specified"
66
ms.reviewer: ""
77
ms.service: "sql-data-warehouse"
@@ -145,7 +145,7 @@ Assigns each row to one distribution by hashing the value stored in *distributio
145145
Distributes the rows evenly across all the distributions in a round-robin fashion. This is the default for [!INCLUDE[ssSDW](../../includes/sssdw-md.md)].
146146

147147
`DISTRIBUTION = REPLICATE`
148-
Stores one copy of the table on each Compute node. For [!INCLUDE[ssSDW](../../includes/sssdw-md.md)] the table is stored on the first distribution database of each Compute node. For [!INCLUDE[ssPDW](../../includes/sspdw-md.md)], the table is stored in a [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] filegroup that spans the Compute node. This is the default for [!INCLUDE[ssPDW](../../includes/sspdw-md.md)].
148+
Stores one copy of the table on each Compute node. For [!INCLUDE[ssSDW](../../includes/sssdw-md.md)] the table is stored on a distribution database on each Compute node. For [!INCLUDE[ssPDW](../../includes/sspdw-md.md)], the table is stored in a [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] filegroup that spans the Compute node. This is the default for [!INCLUDE[ssPDW](../../includes/sspdw-md.md)].
149149

150150
### <a name="TablePartitionOptions"></a> Table partition options
151151
For guidance on using table partitions, see [Partitioning tables in SQL Data Warehouse](https://azure.microsoft.com/documentation/articles/sql-data-warehouse-tables-partition/).

0 commit comments

Comments
 (0)