Post reply

sysname data type?

  • 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

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply