Can't see indexes on AzureDB created in SQL Server Management Studio

aSystemOverload's profile image aSystemOverload posted 5 years ago in General Permalink

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

ansgar's profile image ansgar posted 5 years ago Permalink

You could post the create code of that table here, not the one provided by HeidiSQL's table editor but from SSM Studio.

aSystemOverload's profile image aSystemOverload posted 5 years ago Permalink

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.