I created two indexes within 'SQL Server Management Studio', but can't see them in Heidi.
BackEnd: Microsoft SQL Azure (RTM) - 12.0.2000.8 Jul 3 2019 10:02:53 Copyright (C) 2019 Microsoft Corporation
I created two indexes within 'SQL Server Management Studio', but can't see them in Heidi.
BackEnd: Microsoft SQL Azure (RTM) - 12.0.2000.8 Jul 3 2019 10:02:53 Copyright (C) 2019 Microsoft Corporation
I've removed a number of fields and obscured the remainder.
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Report_Account](
[AccountID] [uniqueidentifier] NOT NULL,
[ASDFASDF] [decimal](18, 0) NULL,
[asdffasdf] [bit] NULL,
[asgdfasdf] [bit] NULL,
[ashdfasdf] [bit] NULL,
[asdyfsdf] [bit] NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [AccountID] ON [dbo].[Report_Account]
(
[AccountID] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
Let me know if you need anything further.
Please login to leave a reply, or register at first.