Skip to content

Instantly share code, notes, and snippets.

@MarkPryceMaherMSFT
Created April 4, 2022 22:34
Show Gist options
  • Save MarkPryceMaherMSFT/39fc62ce2a91ca43bf6c274dab088b38 to your computer and use it in GitHub Desktop.
Save MarkPryceMaherMSFT/39fc62ce2a91ca43bf6c274dab088b38 to your computer and use it in GitHub Desktop.
pdw_table_mappings
create table test_table
(
col_a int,
col_b int
) with ( distribution=round_robin)
declare @table_object_id bigint;
select object_id, * from sys.tables where name like 'test_table'
select @table_object_id = object_id from sys.tables where name like 'test_table'
-- real name for each table
select * from sys.pdw_table_mappings where object_id = @table_object_id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment