Query column names from tables

Hey there. I'm very new here, trying to wrap my head around Swis. Is there any way to list column names for a table via Swis? For example, I can select 'Name' from Metadata.Entity to gtet a list of tables. Doing so, I found SnmpCredential. Now I'd like to get a list of the available columns in SnmpCredential. But I'll be darned if I can find a way to get the list......

Find more posts tagged with

swis

tables

columns

Accepted answers

All comments

adam.beedell

In SWQL studio, this is open the table, or double click it. Way easier than every other method.

adam.beedell

(SWIS itself doesnt allow Select * from, which would normally be the method)

sum_giais

Here's an example of a basic query looking at a SWIS entity (Orion.Nodes) and the properties attached to it. But yes, as @adam.beedell noted, in SWQL studio you can easily get an idea of how all this stuff is connected and their properties attached far quicker than this. But if you're looking for something quick and easy to point at various SWIS entities, this queries could get you going.

-- Here's a select on all the properties in the Metadata.Property SWIS entity
--
-- SELECT TOP 1000 Name, Type, IsMetric, Units, MaxValue, MinValue, Values, IsNavigable, IsKey, IsNullable, IsInherited, IsInjected, IsSortable, GroupBy, FilterBy, CanCreate, CanRead, CanUpdate, Events, Summary, IsObsolete, ObsolescenceReason, IsInternal, EntityName, DisplayName, Description, InstanceType, Uri, InstanceSiteId
-- FROM Metadata.Property

SELECT
     m.EntityName AS [Entity]
    ,m.Name AS [Field]
    ,m.Type AS [DataType]
FROM Metadata.Property AS m
WHERE m.EntityName = 'Orion.Nodes'