Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Jun 21st, 2012  |  syntax: None  |  size: 0.73 KB  |  hits: 7  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Drop a column from table problem (SQL Server 2008)
  2. CREATE TABLE [dbo].[Users](
  3.     [U_Id] [int] IDENTITY(101,1) NOT NULL,
  4.     [U_Name] [nvarchar](50) NULL,
  5.     [U_Family] [nvarchar](50) NULL,
  6.  CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED
  7. (
  8.     [U_Id] ASC
  9. ),
  10.  CONSTRAINT [IX_UserIdUnique] UNIQUE NONCLUSTERED
  11. (
  12.     [U_UserId] ASC
  13. )
  14. ) ON [PRIMARY]
  15. GO
  16.  
  17. CREATE UNIQUE NONCLUSTERED INDEX [IX_Users(UserId)] ON [dbo].[Users]
  18. (
  19.     [U_Id] ASC
  20. )
  21. INCLUDE ( [U_Name],
  22. [U_Family]) ) ON [PRIMARY]
  23. GO
  24.        
  25. CREATE UNIQUE NONCLUSTERED INDEX [IX_Users(UserId)] ON [dbo].[Users]
  26. (
  27.     [U_Id] ASC
  28. )
  29. INCLUDE ( [U_Name],
  30. [U_Family])) ON [PRIMARY]
  31. GO
  32.        
  33. CREATE UNIQUE NONCLUSTERED INDEX [IX_Users(UserId)]
  34.   ON [dbo].[Users]([U_Id] ASC)
  35.   WITH DROP_EXISTING
create a new version of this paste RAW Paste Data