Thursday, June 14, 2018

Sql Assistant - Part 2 Working with Table

Note:
The following Database is not my company's official or part of my company's official database, the screenshot showing Northwind DB, which is a test Database available on Internet for testing purpose, and this demo is using SQL-EXPRESS Edition,
Listing all tables
once it connected with the Database , it will automatically list all the tables on it's left panel side.


Getting Structure
to get structure of the table, first we have to select the table, you can select it from the list showing on Left side panel, and by giving double-click , it will list the structure.

on the above picture ,you can see, this tools listing the information that contains
1.Col-name
2.Datatype
3.Size of the column
4.Constraints (by using this column, we can know,the table has reference )
5.Reference table name
6.Constraints name
7.Delete Action
8.Update Action

Listing NOT NULLS
On the second Tab , it is listing NOT NULL columns,

Listing Stored Procedures,Views and Functions that is using the selected table
you can see the third column listing all stored procedures,vies and functions using the selected table.

Listing Child Table
On Fourth column you can see, it is listing child tables, which is referring this table.

this tab contained following information:
1. Constraint name of current table primarykey
2. Foreign Key Column
3. Referencing table
4. Referencing column
5. Parent table
6. Parent table column
will continue...

No comments:

Post a Comment

Analyser Different types of charts to Analyse a symbol

Analyser has in-built charts to analyse a selective symbol here is the example