123456789101112131415161718192021222324252627282930313233343536373839404142434445464748 |
- IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[NewMeterZC]') AND type IN ('U'))
- DROP TABLE [dbo].[NewMeterZC]
- GO
- CREATE TABLE [dbo].[NewMeterZC] (
- [PKID] bigint NOT NULL,
- [NewMeterTM] varchar(50) COLLATE Chinese_PRC_CI_AS NULL,
- [Operator] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
- [OperateTime] datetime NULL,
- [ReturnTime] datetime NULL,
- [NewMeterZC] varchar(50) COLLATE Chinese_PRC_CI_AS NULL
- )
- GO
- ALTER TABLE [dbo].[NewMeterZC] SET (LOCK_ESCALATION = TABLE)
- GO
- ALTER TABLE [dbo].[NewMeterZC] ADD CONSTRAINT [PK__NewMeter__5E0282721DE57479] PRIMARY KEY CLUSTERED ([PKID])
- WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
- ON [PRIMARY]
- GO
|