This report is not available in SQL Change Automation Core.Find out more
SQL Change Automation SQL Change Automation Created 7 years ago
Script Warnings (0) Changes (1)
Help Give feedback Redgate logo
0 Added  0 Removed  1 Modified 
Expand all  |  Collapse all
dlmautomation_9825a4e4-359a-46fb-99c3-d42a494e3057
np:\\.\pipe\LOCALDB#F22C15A2\tsql\query
adventureworks
sqlchangeautomation.database.windows.net
Modified  SalesLT.Address
Table
  • CREATE TABLE [SalesLT].[Address]
  • (
  • [AddressID] [int] NOT NULL IDENTITY(1, 1),
  • [AddressLine1] [nvarchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
  • [AddressLine2] [nvarchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  • [City] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
  • [StateProvince] [dbo].[Name] NOT NULL,
  • [CountryRegion] [dbo].[Name] NOT NULL,
  • [PostalCode] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
  • [rowguid] [uniqueidentifier] NOT NULL CONSTRAINT [DF_Address_rowguid] DEFAULT (newid()),
  • [ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_Address_ModifiedDate] DEFAULT (getdate())
  • )
  • GO
  • ALTER TABLE [SalesLT].[Address] ADD CONSTRAINT [PK_Address_AddressID] PRIMARY KEY CLUSTERED ([AddressID])
  • GO
  • CREATE NONCLUSTERED INDEX [IX_Address_AddressLine1_AddressLine2_City_StateProvince_PostalCode_CountryRegion] ON [SalesLT].[Address] ([AddressLine1], [AddressLine2], [City], [StateProvince], [PostalCode], [CountryRegion])
  • GO
  • - CREATE NONCLUSTERED INDEX [IX_SalesLTAddress_ModifiedDate] ON [SalesLT].[Address] ([ModifiedDate] DESC)
  • - GO
  • ALTER TABLE [SalesLT].[Address] ADD CONSTRAINT [AK_Address_rowguid] UNIQUE NONCLUSTERED ([rowguid])
  • GO
  • CREATE NONCLUSTERED INDEX [IX_Address_StateProvince] ON [SalesLT].[Address] ([StateProvince])
  • GO
No content to display