MS SQL Server Database Query Tool Features

The MS SQL Server database query tool features provided by RazorSQL include a custom database browser tailored to SQL Server, a Transact-SQL SQL editor with Transact SQL and SQL Server specific features and syntax highlighting, custom SQL Server visual tools, and SQL Server specific database administration tools. Listed below are more details on these features.

SQL Server Visual Tools

  • A SQL Server create table tool that generates SQL Server specific create table SQL that includes such elements as column names, column types, column lengths or precisions, column scales, nullability, unique constraints, default values, identity, identity start and end, and the ability to add check constraints.
  • A SQL Server create view tool that generates the SQL for creating SQL Server views
  • A SQL Server create index tool that generates the SQL for creating SQL Server indexes and includes elements such as index name, uniqueness, and columns
  • A SQL Server create procedure tool for generating the TSQL to create SQL Server procedures
  • A SQL Server create function tool for generating the TSQL to create SQL Server functions
  • A SQL Server create trigger tool for generating the TSQL to create SQL Server triggers
  • A SQL Server create database tool that generates the SQL Server create database SQL with elements such as database name, logical file name, file name, size, max size, file growth, collation, etc.
  • A SQL Server alter table tool for generating the SQL to alter SQL Server tables with such options as add column, add primary key, add foreign key, add constraint, rename table, rename column, drop column, drop primary key, drop foreign key, and drop constraint
  • A SQL Server alter view tool for generating the SQL to alter SQL Server views
  • SQL Drop Tools for dropping tables, views, indexes, procedures, functions, and triggers for SQL Server
  • A visual edit table tool for visually editing SQL Server tables in a spreadsheet format
  • Tools for editing procedures, functions, and triggers for SQL Server.
  • SQL Server Import and Export tools for importing data into tables, or exporting data from single tables or all tables in a database

SQL Server Database Browser

  • Displays information in a tree format for databases, tables, views, procedures, functions, triggers, indexes, constraints, users, and roles
  • Displays SQL Server table information such as column name, column type, column length, column nullability, and primary and foreign key information
  • Easily view table contents or database object information via the View Contents and Show Info context menu options