SQL hints [#sequence #primaryKey #pk #default #newid]

[fjtello]

CREATE SEQUENCE [dbo].[seq_logs] AS [int] START WITH 1 INCREMENT BY 1 MINVALUE -2147483648 MAXVALUE 2147483647 CACHE GO

alter sequence dbo.seq_logs restart with 1; GO

CREATE TABLE [dbo].[LOGS]( [idLog] [int] NOT NULL, [fecha] [datetime] NOT NULL, [origen] varchar NULL, [accion] varchar NULL, [descripcion] varchar NULL, [rastro] varchar NULL, CONSTRAINT [PK_LOGS] PRIMARY KEY CLUSTERED ( [idLog] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

ALTER TABLE [dbo].[LOGS] ADD CONSTRAINT [DF_LOGS_idLog] DEFAULT (NEXT VALUE FOR [dbo].[seq_Logs]) FOR [idLog] GO

ALTER TABLE [dbo].[LOGS] ADD CONSTRAINT [DF_LOGS_fecha] DEFAULT (getdate()) FOR [fecha] GO

ALTER TABLE [dbo].[LOGS] ADD CONSTRAINT [DF_LOGS_rastro] DEFAULT (newid()) FOR [rastro] GO