■ CREATE TABLE AS 사용하기

----------------------------------------------------------------------------------------------------

CREATE TABLE dbo.NewStudent

(

    ID   VARCHAR(10)  NOT NULL

   ,NAME VARCHAR(100) NOT NULL

)

WITH

(

    DISTRIBUTION = HASH(ID)

   ,CLUSTERED COLUMNSTORE INDEX

)

AS

SELECT

    ID

   ,NAME

FROM dbo.Student;

----------------------------------------------------------------------------------------------------

Posted by 사용자 icodebroker
TAG

댓글을 달아 주세요