SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [MADD]( [ADD_CD] [nvarchar](10) NOT NULL, [ADD_BK_FLG] [numeric](1, 0) NULL, [UP_DT] [nvarchar](8) NULL, [CO_NM] [nvarchar](80) NULL, [ADDRESS] [nvarchar](120) NULL, [CO_NM_SORT] [nvarchar](40) NULL, [E_CO_NM] [nvarchar](80) NULL, [E_ADDRESS] [nvarchar](120) NULL, [ZIP] [nvarchar](10) NULL, [SUBAC_CD] [nvarchar](10) NULL, [TRANSFER_CD] [nvarchar](10) NULL, [ENTRY_DATE] [datetime2](0) NULL, [UP_DATE] [datetime2](0) NULL, [APP_USRCD] [nvarchar](15) NULL, [COM_CD] [nvarchar](10) NULL, [USRCD] [nvarchar](15) NULL, [ITWC_FLG] [numeric](1, 0) NULL, [RSRV_FLG] [numeric](1, 0) NULL, [INV_FLG] [numeric](1, 0) NULL, [EXCEPT_SCT_CD] [nvarchar](10) NULL, [ADDCL1_CD] [nvarchar](10) NULL, [ADDCL2_CD] [nvarchar](10) NULL, [ADDCL3_CD] [nvarchar](10) NULL, CONSTRAINT [MADD_PRIMARY] PRIMARY KEY CLUSTERED ( [ADD_CD] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [MADD] SET (LOCK_ESCALATION = DISABLE) GO ALTER TABLE [MADD] WITH CHECK ADD CONSTRAINT [CK_MADD] CHECK (([ADD_CD]<>'' AND [UP_DT]<>'' AND [CO_NM]<>'' AND [ADDRESS]<>'' AND [CO_NM_SORT]<>'' AND [E_CO_NM]<>'' AND [E_ADDRESS]<>'' AND [ZIP]<>'' AND [SUBAC_CD]<>'' AND [TRANSFER_CD]<>'' AND [APP_USRCD]<>'' AND [COM_CD]<>'' AND [USRCD]<>'' AND [EXCEPT_SCT_CD]<>'' AND [ADDCL1_CD]<>'' AND [ADDCL2_CD]<>'' AND [ADDCL3_CD]<>'')) GO ALTER TABLE [MADD] CHECK CONSTRAINT [CK_MADD] GO ALTER TABLE [MADD] WITH NOCHECK ADD CONSTRAINT [MADD_CHECK_4218] CHECK ((coalesce([ITWC_FLG],(0))<>(3))) GO ALTER TABLE [MADD] CHECK CONSTRAINT [MADD_CHECK_4218] GO EXEC sys.sp_addextendedproperty @name=N'COLUMN_COMMENT', @value=N'取引先コード' , @level0type=N'SCHEMA',@level0name=N'GXO', @level1type=N'TABLE',@level1name=N'MADD', @level2type=N'COLUMN',@level2name=N'ADD_CD' GO EXEC sys.sp_addextendedproperty @name=N'COLUMN_COMMENT', @value=N'取引先・銀行区分' , @level0type=N'SCHEMA',@level0name=N'GXO', @level1type=N'TABLE',@level1name=N'MADD', @level2type=N'COLUMN',@level2name=N'ADD_BK_FLG' GO EXEC sys.sp_addextendedproperty @name=N'COLUMN_COMMENT', @value=N'更新日' , @level0type=N'SCHEMA',@level0name=N'GXO', @level1type=N'TABLE',@level1name=N'MADD', @level2type=N'COLUMN',@level2name=N'UP_DT' GO EXEC sys.sp_addextendedproperty @name=N'COLUMN_COMMENT', @value=N'取引先名' , @level0type=N'SCHEMA',@level0name=N'GXO', @level1type=N'TABLE',@level1name=N'MADD', @level2type=N'COLUMN',@level2name=N'CO_NM' GO EXEC sys.sp_addextendedproperty @name=N'COLUMN_COMMENT', @value=N'住所' , @level0type=N'SCHEMA',@level0name=N'GXO', @level1type=N'TABLE',@level1name=N'MADD', @level2type=N'COLUMN',@level2name=N'ADDRESS' GO EXEC sys.sp_addextendedproperty @name=N'COLUMN_COMMENT', @value=N'取引先カナ' , @level0type=N'SCHEMA',@level0name=N'GXO', @level1type=N'TABLE',@level1name=N'MADD', @level2type=N'COLUMN',@level2name=N'CO_NM_SORT' GO EXEC sys.sp_addextendedproperty @name=N'COLUMN_COMMENT', @value=N'取引先名(英文)' , @level0type=N'SCHEMA',@level0name=N'GXO', @level1type=N'TABLE',@level1name=N'MADD', @level2type=N'COLUMN',@level2name=N'E_CO_NM' GO EXEC sys.sp_addextendedproperty @name=N'COLUMN_COMMENT', @value=N'住所(英文)' , @level0type=N'SCHEMA',@level0name=N'GXO', @level1type=N'TABLE',@level1name=N'MADD', @level2type=N'COLUMN',@level2name=N'E_ADDRESS' GO EXEC sys.sp_addextendedproperty @name=N'COLUMN_COMMENT', @value=N'郵便番号' , @level0type=N'SCHEMA',@level0name=N'GXO', @level1type=N'TABLE',@level1name=N'MADD', @level2type=N'COLUMN',@level2name=N'ZIP' GO EXEC sys.sp_addextendedproperty @name=N'COLUMN_COMMENT', @value=N'補助科目コード' , @level0type=N'SCHEMA',@level0name=N'GXO', @level1type=N'TABLE',@level1name=N'MADD', @level2type=N'COLUMN',@level2name=N'SUBAC_CD' GO EXEC sys.sp_addextendedproperty @name=N'COLUMN_COMMENT', @value=N'振込先コード' , @level0type=N'SCHEMA',@level0name=N'GXO', @level1type=N'TABLE',@level1name=N'MADD', @level2type=N'COLUMN',@level2name=N'TRANSFER_CD' GO EXEC sys.sp_addextendedproperty @name=N'COLUMN_COMMENT', @value=N'登録日時' , @level0type=N'SCHEMA',@level0name=N'GXO', @level1type=N'TABLE',@level1name=N'MADD', @level2type=N'COLUMN',@level2name=N'ENTRY_DATE' GO EXEC sys.sp_addextendedproperty @name=N'COLUMN_COMMENT', @value=N'更新日時' , @level0type=N'SCHEMA',@level0name=N'GXO', @level1type=N'TABLE',@level1name=N'MADD', @level2type=N'COLUMN',@level2name=N'UP_DATE' GO EXEC sys.sp_addextendedproperty @name=N'COLUMN_COMMENT', @value=N'更新者' , @level0type=N'SCHEMA',@level0name=N'GXO', @level1type=N'TABLE',@level1name=N'MADD', @level2type=N'COLUMN',@level2name=N'APP_USRCD' GO EXEC sys.sp_addextendedproperty @name=N'COLUMN_COMMENT', @value=N'企業コード' , @level0type=N'SCHEMA',@level0name=N'GXO', @level1type=N'TABLE',@level1name=N'MADD', @level2type=N'COLUMN',@level2name=N'COM_CD' GO EXEC sys.sp_addextendedproperty @name=N'COLUMN_COMMENT', @value=N'従業員コード' , @level0type=N'SCHEMA',@level0name=N'GXO', @level1type=N'TABLE',@level1name=N'MADD', @level2type=N'COLUMN',@level2name=N'USRCD' GO EXEC sys.sp_addextendedproperty @name=N'COLUMN_COMMENT', @value=N'倉庫区分' , @level0type=N'SCHEMA',@level0name=N'GXO', @level1type=N'TABLE',@level1name=N'MADD', @level2type=N'COLUMN',@level2name=N'ITWC_FLG' GO EXEC sys.sp_addextendedproperty @name=N'COLUMN_COMMENT', @value=N'予約区分' , @level0type=N'SCHEMA',@level0name=N'GXO', @level1type=N'TABLE',@level1name=N'MADD', @level2type=N'COLUMN',@level2name=N'RSRV_FLG' GO EXEC sys.sp_addextendedproperty @name=N'COLUMN_COMMENT', @value=N'出庫区分' , @level0type=N'SCHEMA',@level0name=N'GXO', @level1type=N'TABLE',@level1name=N'MADD', @level2type=N'COLUMN',@level2name=N'INV_FLG' GO EXEC sys.sp_addextendedproperty @name=N'COLUMN_COMMENT', @value=N'除外する部門' , @level0type=N'SCHEMA',@level0name=N'GXO', @level1type=N'TABLE',@level1name=N'MADD', @level2type=N'COLUMN',@level2name=N'EXCEPT_SCT_CD' GO EXEC sys.sp_addextendedproperty @name=N'COLUMN_COMMENT', @value=N'取引先分類1コード' , @level0type=N'SCHEMA',@level0name=N'GXO', @level1type=N'TABLE',@level1name=N'MADD', @level2type=N'COLUMN',@level2name=N'ADDCL1_CD' GO EXEC sys.sp_addextendedproperty @name=N'COLUMN_COMMENT', @value=N'取引先分類2コード' , @level0type=N'SCHEMA',@level0name=N'GXO', @level1type=N'TABLE',@level1name=N'MADD', @level2type=N'COLUMN',@level2name=N'ADDCL2_CD' GO EXEC sys.sp_addextendedproperty @name=N'COLUMN_COMMENT', @value=N'取引先分類3コード' , @level0type=N'SCHEMA',@level0name=N'GXO', @level1type=N'TABLE',@level1name=N'MADD', @level2type=N'COLUMN',@level2name=N'ADDCL3_CD' GO EXEC sys.sp_addextendedproperty @name=N'TABLE_COMMENT', @value=N'住所' , @level0type=N'SCHEMA',@level0name=N'GXO', @level1type=N'TABLE',@level1name=N'MADD' GO
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear