[DATABASE/PDW] CREATE TABLE 명령 : 날짜 PARTITION 설정하기

icodebroker PDW 2024-06-18

■ CREATE TABLE 명령을 사용해 날짜 PARTITION을 설정하는 방법을 보여준다.

▶ 예제 코드 (SQL)


CREATE TABLE dbo.Student
(
    ID            INT            NOT NULL
   ,Name          NVARCHAR(100)  NOT NULL
   ,Birthday      DATETIME       NULL
   ,[Description] NVARCHAR(4000) NULL
)
WITH
(
    DISTRIBUTION = HASH(ID)
   ,CLUSTERED INDEX (ID)
   ,PARTITION (BirthDay RANGE RIGHT FOR VALUES('1992-01-01', '1993-01-01', '1994-01-01')
);

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

CREATE TABLE dbo.Student

(

ID INT NOT NULL

,Name NVARCHAR(100) NOT NULL

,Birthday DATETIME NULL

,[Description] NVARCHAR(4000) NULL

)

WITH

(

DISTRIBUTION = HASH(ID)

,CLUSTERED INDEX (ID)

,PARTITION (BirthDay RANGE RIGHT FOR VALUES('1992-01-01', '1993-01-01', '1994-01-01')

);