MSSQL: 資料表異動-修改欄位定序

ALTER TABLE TableName ALTER COLUMN ColumnName 欄位類型及長度 COLLATE 定序格式;
-- sample
ALTER TABLE TBORG_AREA_MAPPING ALTER COLUMN TELLERID varchar(10) COLLATE Chinese_PRC_CS_AS;

★若欄位有被設成索引(index)，需先將index移除重建
-- sample
ALTER TABLE TBAST_STK_LOG DROP CONSTRAINT PK_TBAST_STK_LOG;
DROP INDEX IDX_TBAST_STK_LOG_01 ON TBAST_STK_LOG;
ALTER TABLE TBAST_STK_LOG ALTER COLUMN MKT_CODE varchar(8) NOT NULL;
ALTER TABLE TBAST_STK_LOG ADD CONSTRAINT PK_TBAST_STK_LOG PRIMARY KEY (ORDERDT, ACCOUNT, STKID, TRANSACTIONID, MKT_CODE);
CREATE INDEX IDX_TBAST_STK_LOG_01 ON TBAST_STK_LOG(MKT_CODE, ORDERDT);