Virtual Table – System Object

 

Hey Friends,

As we all know there are Virtual Tables as well as System Tables. So for recognizing System Objects there’s a Virtual table – System Object. This simply consists of all the System tables which are available in the NAV System.

Untitled

This Virtual Table consists of the above Fields with information as –

Object – Either it’s a Table, Page,Report and so on.

ObjectID – Unique ID of the Object.

Object Name – Name of the Object.

Object Caption – Caption of the Object.

Cheers.

Advertisements

Virtual Table – Key

 

Hey Friends,

This Post is about Virtual Table – KeyKey virtual table contains information about all the keys that are defined in each and every table in the database. Again like if you want to get the complete information of the keys the Standard and the one you created then can hit this virtual table. As we all know Sum Index Fields makes our work a way more easier but it’s too been recommended not to use too much of this as it reduces performance as that of Flow Fields.

So if you want to calculate how much Sum Index Fields you have made in the entire Database then you can hit this virtual table.

Untitled

This virtual table gives you the following Information’s –

TableNo –  ID of the Table.

No. – Its a sequential ID assigned for multiple fields of the same Table.

TableName – Name of the Table.

Key – Combination of Fields that makes the Key.

SumIndexField – SumIndexFields defined for that Key.

SQLIndex –  Actual fields that have been defined in Microsoft Dynamics NAV and are used in the corresponding index on SQL Server instead of those defined in the key.

Enabled – Either the Field is Enabled or not.

MaintainSQLIndex – MaintainSQLIndex property has been activated or not. This field can be modified.

MaintainSIFTIndex – MaintainSIFTIndex property has been activated. This field can be modified.

Clustered – Either the Key is Clustered or not. This field can be modified.

Cheers.

 

Virtual Table – Field

 

Hey Folks,

This Post is about Virtual Table – Field. Field virtual table contains information about all the fields of all the Tables in the Database. If at any time you want the complete specification of the Fields from development perspective then this virtual Table is for you. You can even use this Virtual Table for comparing the fields of different tables for any sort of queries you have.

Untitled

This Table consists of following specifications –

TableNo –  ID of the Table.

No. – Its a sequential ID assigned for multiple fields of the same Table.

TableName – Name of the Table.

FieldName – Name of the Field.

Type – Data Type of the Field.

Len – Length of the field(Bytes).

Class – Class of the field – FlowField,FlowFilter.

Enabled – Whether the field is enabled.

Type Name –  Data type assigned to the field with Length(Code,Text).

Field Caption –  Caption of the field in the language that has been selected.

RelationTableNo – ID of the Table on to which the Field is related.

RelationFieldNo – Number of the field in another table that the field is related to.

SQLDataType – Data type assigned to code fields.

Cheers

Virtual Table – Table Information

 

Hey,

This Post is about a Virtual Table – Table Information. Table Information gives the complete information of the Database Tables. You can Commutatively come to know about the load of each and every Tables of the Database in a single go.

Untitled

Company Name – Name of the Company.

Table No. – Unique ID of the Table.

Table Name – Name of the Table.

No. of Records – Number of Records in the Table.

Record Size – It’s an average size of the Record, calculated as 1024 x Size (KB)/Records.

Size (KB) – Space Occupied by the database in Table(KB).

Cheers

 

Virtual Table – Drive

Hey Friends,

This Post is all about a Virtual Table – Drive. Though many of us might not got the need to have an experience of this but this seems very useful if you have a very least access on your computer Drives and you don’t know which drive has how much of space and either it’s Removable or not.

Let’s see make a Page from the standard Dynamics NAV Wizard.

Untitled

Drive The available Drive in the System.

Removable Indicates whether the disk is removable (a CD-ROM or similar) or a Hard Disk.

Size(KB) – Total size of the disk.

Free(KB) Amount of free space on the disk

CHEERS