DDL view incorrect identity increment value

• 
  Hi,
  
  I'm afraid I can't reproduce your problem. Could you give me a more detailed example?
  
  Regards,
  
  Tilman

  Tilman December 20, 2006 07:04

  - 0 +
• 
  CREATE TABLE [dbo].[Address]
  (
  [addressId] [int] NOT NULL IDENTITY(1, 1),
  [line1StreetAddress] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  [line2StreetAddress] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  [cityName] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
  [zipCode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
  [stateCode] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
  [countyName] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
  )
  
  
  Above is what is shown in my DDL view when in fact it should look like this.
  
  CREATE TABLE [dbo].[Address]
  (
  [addressId] [int] NOT NULL IDENTITY(1, 4),
  [line1StreetAddress] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  [line2StreetAddress] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  [cityName] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
  [zipCode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
  [stateCode] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
  [countyName] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
  )

  katokay December 20, 2006 09:23

  - 0 +
• 
  Sorry, I still can't get it. Could it be that you made some changes to your schema and forgot to refresh the cache?
  
  Regards,
  
  Tilman

  Tilman December 20, 2006 09:38

  - 0 +
• 
  Yes, it works and that must have been it. I have recently restored from a backup and apparently it was using the old information. Sorry for the false alarm.

  katokay December 21, 2006 00:13

  - 0 +

Add comment

Please sign in to leave a comment.