sysname data type?

• cpyne

  Mr or Mrs. 500

  Points: 572

  More actions

  July 27, 2010 at 1:13 pm

  #227252

  Hi,

  Here's a sample create index statement that was generated with SQL 2008 Management Studio...

  CREATE NONCLUSTERED INDEX [I_TimeQueue, sysname,>]

  ON [dbo].[TimeQueue] ([RuleInstanceId],[TriggerTime])

  GO

  Can anyone explain what the "sysname,>" part is? The definition of sysname on msdn is pretty strait forward, but it seems weird that this option isn't listed in the CREATE INDEX t-sql syntax. (see links below) Also, what is the significance of the ",>" parameter at the end?

  Thanks

  Charlie

  http://msdn.microsoft.com/en-us/library/ms191240.aspx

  http://msdn.microsoft.com/en-us/library/ms188783.aspx

• matt6288

  SSCertifiable

  Points: 5058

  More actions

  July 27, 2010 at 2:32 pm

  #1198967

  It looks like this is part of a template. In SSMS if you hit CTRL+ALT+T it will display the templates. Expand the index section and double click on the Create Index Basic template. You can then hit CTRL+SHIFT+M and fill in the variables. They are displayed in <variable, datatype, example> format.