Post reply

Script collation clause

  • May 23, 2007 at 9:17 am

    #116970

    In SQL2000, in Query Analyzer, Tools, Options, Script, you could say "Do not script the collation clause."  Does anyone know if this option exists in SQL2005 SSMS?  I can't find it in any of the options, and it is turned on by default, so if I script a table it inserts the collate clause for each field.  I would like to turn that off.

    Thank you.

    Holly Kilpatrick

  • May 23, 2007 at 10:03 am

    #708372

    You can turn this option off when using the SQL Server Scripts Wizard.  You start it by selecting Generate Scripts when right clicking on a database in Object Explorer.

  • May 24, 2007 at 7:16 am

    #708619

    Lynn,

    Thank you very much.  I never tried this, because I script tables by right clicking on the table in Object Explorer, and that option is not available there.  This is a roundabout way to script one table, but if I want the result without the collation clauses, I am glad to see there is a way to get it.  I appreciate your response.

    Holly

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

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