This post briefly explains the different views available for Managing a Table’s definition using Data Utensil.
This is where you can view the columns, indexes and foreign keys of a Table.
Table definition is comprised of several views:-
This view shows the columns of a table and their properties such as:-
- Data Type – The datatype of the column.
- Size – The size of the column (if applicable)
- Precision – The precision of the column (if applicable)
- Scale – The scale of the column (if applicable)
- Primary Key – Whether or not the column is part of the Primary Key
- Nullable – Whether or not the column can store NULL values
- Unique – Whether the values of the column must be unique
- Identity – Whether it is an Identity column of SQL Server whose values are automatically generated by the database on insertion
- Collation – The collation of the column
Indexes for this table along with their properties are listed here.
- Type – The type of the Index – Clustered, Non Clustered, etc
- Name – The name of the Index
- Columns – The columns on which the Index applies
- Unique – Whether it is a Unique Index
- Primary Key – Whether it is a Primary Key Index
Foreign keys of the table and their properties are found here.
- Constraint Name – The name of the foreign key constraint
- Referenced Table – The referenced (Master) table of the foreign key
- Referencing Table – The referencing (Child) table of the foreign key
- Referenced Columns – The columns in the master table which are part of the foreign key
- Referencing Columns – The columns in the child table which are part of the foreign key
- On Update – The ON UPDATE rule for the foreign key
- On Delete – THe ON DELETE rule for the foreign key
This view shows the SQL query that can be used to create the Table.
As you make changes to an existing table or add columns, indexes and foreign keys to a new table, the SQL that will be fired to make the changes are shown in this view.
This view shows the basic properties for the table such as its’ Name, Schema, etc.