Navicat For SQL Server

30-04-2021
 |  [RAND-100] - Comments



SQL Server Table Foreign Keys. A foreign key is a field in a relational table that matches the primary key column of another table. The foreign key can be used to cross-reference tables. In the Foreign Keys tab, just simply click a foreign key field for editing. By using the foreign key toolbar, you can create new, edit and delete the selected. Navicat for SQL Server is an ideal solution for SQL Server administration and development which lets you create, edit databases, run SQL queries and connect to remote SQL Server in an easier way. It features an intuitive GUI and offers powerful visual tools such as Query Editor with syntax highlight capability, SQL Preview, SQL Console, TEXT.

SQL Server Triggers

A trigger is a special kind of stored procedure that automatically executes when an event occurs in the database server. Click -> Trigger to open an object list for Trigger.

See Triggers for details.

Note: SQL Azure does not support the Comment tab.

General Properties

Trigger Type
Choose Table or View on which the DML trigger is executed.

Enable
Check this option to enable the trigger.

Table name or View name
Choose a table or a view.

AFTER
Specify that the DML trigger is fired only when all operations specified in the triggering SQL statement have executed successfully.

INSTEAD OF
Specify that the DML trigger is executed instead of the triggering SQL statement, therefore, overriding the actions of the triggering statements.

Insert
The trigger is activated whenever a new row is inserted into the table.

Delete
The trigger is activated whenever a row is deleted from the table.

Update
The trigger is activated whenever a row is modified.

SQL Statement
Specify additional criteria in Definition tab.

Note: Support from SQL Server 2005 or later.

Assembly
Specify the method of an assembly to bind with the trigger.

Note: Support from SQL Server 2005 or later.

Advanced Properties

Caller
Specify the statements inside the module are executed in the context of the caller of the module.

For

Note: Support from SQL Server 2005 or later and SQL Azure.

Owner
Specify the statements inside the module executes in the context of the current owner of the module.

Note: Support from SQL Server 2005 or later and SQL Azure.

Self
Specify the statements inside the module are executed in the context of the specified user is the person creating or altering the module.

Note: Support from SQL Server 2005 or later and SQL Azure.

User
Specify the statements inside the module execute in the context of the user.

Note: Support from SQL Server 2005 or later and SQL Azure.

Encrypted
Obfuscate the text of the CREATE TRIGGER statement.

Note: Support from SQL Server 2005 or later.

Not For Replication
Indicate that the trigger should not be executed when a replication agent modifies the table that is involved in the trigger.

Sql Server W3schools

Note: SQL Azure does not support.

With Append
Specify that an additional trigger of an existing type should be added.

Note: SQL Azure does not support.

Definition

This tab will appear when the Definition Type is set to SQL Statement in General tab or when connecting to SQL Azure. Enter valid SQL statements.

SQL Server Views

A view can be thought of as either a virtual table or a stored query. Unless a view is indexed, its data is not stored in the database as a distinct object. What is stored in the database is a SELECT statement. The result set of the SELECT statement forms the virtual table returned by the view. A user can use this virtual table by referencing the view name in Transact-SQL statements the same way a table is referenced. Click to open an object list for View.

You can create a view shortcut by right-click a view in the Object List pane and select Create Open View Shortcut from the pop-up menu. This option is used to provide a convenient way for you to open your view directly without activating the main Navicat.

Note: SQL Azure does not support the Comment tab.

Description
Preview the result of the view.
Explain
Show the Query Plan of the view.
Format the codes with the Beautify SQL settings in Editor.

Note: You can choose to show the Result tab below the editor or in a new tab by selecting View -> Show Result -> Below Query Editor or In a New Tab.

Sql Server Management Studio

View Builder (Available only in Full Version)

View Builder allows you to build views visually. It allows you to create and edit views without knowledge of SQL. See Query Builder for details.

Definition

You can edit the view definition as SQL statement (SELECT statement it implements).

Hint: To customize the view of the editor and find out more features for sql editing, see Editor Advanced Features.

Advanced Properties

Encrypted
Encrypt the entries in sys.syscomments that contain the text of the CREATE VIEW statement.

Note: SQL Azure does not support.

Schema Bound
Bind the view to the schema of the underlying table or tables.

View Metadata
Specify that the instance of SQL Server will return to the DB-Library, ODBC, and OLE DB APIs the metadata information about the view, instead of the base table or tables, when browse-mode metadata is being requested for a query that references the view.

With Check Option
Force all data modification statements executed against the view to follow the criteria set within select_statement.

View Viewer

View Viewer displays the view data as a grid. Data can be displayed in two modes: Grid View and Form View. See Table Viewer for details.