SQLize | PHPize | SQLtest

USE [VRA523] GO ALTER TABLE [dbo].[AboClasser] DROP CONSTRAINT [DF_AboClasser_Acl_date] GO /****** Object: Table [dbo].[AboClasser] Script Date: 26/02/2025 14:25:31 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AboClasser]') AND type in (N'U')) DROP TABLE [dbo].[AboClasser] GO /****** Object: Table [dbo].[AboClasser] Script Date: 26/02/2025 14:25:31 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[AboClasser]( [Acl_code] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL, [Acl_date] [smalldatetime] NULL, [Acl_operateur] [varchar](5) NOT NULL, CONSTRAINT [PK_AboClasser] PRIMARY KEY NONCLUSTERED ( [Acl_code] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[AboClasser] ADD CONSTRAINT [DF_AboClasser_Acl_date] DEFAULT (CONVERT([smalldatetime],getdate(),0)) FOR [Acl_date] GO ; show status like 'Last_query_cost';