April 21, 2010

SQLWriter Editor is designed for people who work with database. With SQLWriter Editor you can:

Database schema tree

  • shows you comprehensive information about the objects in your databases.
  • not just tables, but also views, aliases, indexes, triggers, procedures, functions, users.
  • the schema can be customized by yourself.
  • the object common can be displayed.
  • the object image can be customized.
  • the object pop menu can be customized.

 

Edit SQL stripts

  • syntax highlighting of SQL.
  • save / retrieve queries.
  • auto completion for tables,views,columns,aliases,procedures,functions and users.
  • the auto completion can be customized by yourself.
  • format SQL.
  • line common filter, if the database not support line common, you can still use it in SQLWriter.
  • batch mode, to run more than one SQL.

 

SQL results

  • edit / update value.
  • save results to csv, html, xml.
  • one click to sort by column, support sort more than one columns.
  • copy / paste row or column.
  • fix row or colum.
  • row number.

 

Export and import

  • export to csv,xml,html.
  • import from xml.
  • record error rows and you can import them again.
  • import data viewer.
  • change column relation.
  • import report.

 

Database template

  • add, delete, edit database objects .
  • customize database schema.
  • customize object pop menu.
  • template copy.
  • oracle, mysql, MS SQL server, DB2 demo template.
  • copy template.
  • active / inactive template.
  • auto select template when connect to database.