Listing fields

To inspect field table on the Data Pump SQL series.

/* Show all fields and properties */
USE ASI2353;
SELECT * 
    FROM [dbo].[Field]
    WHERE [Name] IS NOT NULL
ORDER BY [Position];
-–
/* Show fields which have units */
USE ASI2353;
SELECT [Name], [Unit]
    FROM [dbo].[Field]
    WHERE [Name] IS NOT NULL 
        AND [Unit] IS NOT NULL 
ORDER BY [Position];
-–
/* Show all measurement fields */
USE ASI2353;
SELECT [Name], [Unit]
    FROM [dbo].[Field]
    WHERE [Name] IS NOT NULL 
        AND [IsMeasurement] = 1 
ORDER BY [Position];
-–
/* Show all result fields */
USE ASI2353;
SELECT [Name]
    FROM [dbo].[Field]
    WHERE [Name] IS NOT NULL 
        AND [IsResult] = 1 
ORDER BY [Position];

See more about the fields in the knowledge database.