Community

    • Login
    • Search
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search

    SQL Syntax color code

    Blogs
    notepadd++ syntax colors notepad++v8.1.3
    3
    5
    1962
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • pawan rakesh
      pawan rakesh last edited by

      Hi All,

      Whenever I copy and paste SQL Code from SQL IDE to Notepad++ I see that the entire code/text font color is black

      what I am looking for is to have the font color according to the SQL syntax code( keywords in different color, comments in different color) just like the way you see in any of the IDE’s

      Can you let me know how can I change my settings

      Thanks

      PeterJones 1 Reply Last reply Reply Quote 0
      • PeterJones
        PeterJones @pawan rakesh last edited by

        @pawan-rakesh ,

        If you start with a new/empty tab in Notepad++, it will default to being plain-text / normal text / no styling (you can see this on your status bar in the lower-left corner if your window is wide enough, or by looking at the Language menu and seeing that ● None (Normal Text) is selected). Pasting text which happens to be SQL into the window is not enough to tell Notepad++ that it’s SQL. You have to somehow tell Notepad++ that you’re pasting in SQL. One way is to save the file with the sql extension (like blah.sql). Another way is to go to Language > S > SQL

        PeterJones 1 Reply Last reply Reply Quote 2
        • PeterJones
          PeterJones @PeterJones last edited by

          I said,

          If you start with a new/empty tab in Notepad++, it will default to being plain-text

          BTW: if you are editing more SQL than any other type of file, you might want to change your default syntax highlighter: The Settings > Preferences > New Document has a Default language pulldown; if you change that to SQL, then every new empty file new # (from a File > New or starting a new instance of Notepad++ with no session) will default to SQL instead of normal text.

          pawan rakesh pokemon go 2 Replies Last reply Reply Quote 3
          • pawan rakesh
            pawan rakesh @PeterJones last edited by

            @PeterJones Thank you, it worked

            1 Reply Last reply Reply Quote 0
            • pokemon go
              pokemon go @PeterJones last edited by

              @PeterJones said in SQL Syntax color code:

              I said,

              If you start with a new/empty tab in Notepad++, it will default to being plain-text

              BTW: if you are editing more SQL than any other type of file, you might want to change your default syntax highlighter: The [Settings] > Preferences > New Document has a Default language pulldown; if you change that to SQL, then every new empty file new # (from a File > New or starting a new instance of Notepad++ with no session) will default to SQL instead of normal text.

              I am making new thread.
              i need your help regarding this .
              i request you to reply me on that thread

              1 Reply Last reply Reply Quote 0
              • First post
                Last post
              Copyright © 2014 NodeBB Forums | Contributors