This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 57.00000000000001%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
Hi ,
I want to query a Cube (tabular model) using SSMS to get meta data information ( mostly Column Names , Data-Type).
I am new to SSAS . Can somebody help me here ?
Thanks.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 9%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
Hi,
Using SSMS to get Cube meta data, you could use DMV query to get related info.
Depending on you needs, you could use queries like described in : SSAS: Using DMV Queries to get Cube Metadata
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Users always get connection timeout problem when using multi subnet AG via listener. Especially after failover to another subnet ----Hot issues October
Hi ,
i did see this article however, I want to mainly get the data type of the columns in Tables
I did some research and closet I have got is to the query below :
Select * from $System.DBSchema_Columns
where Table_Schema = '$TableName'
This returns data_type of the columns as '130' for all different types of Columns and I am not sure what '130' does mean.
130 means "wchar" type.
Actually you could run this script to know the number and type relation ：
SELECT DATA_TYPE, TYPE_NAME, COLUMN_SIZE, IS_FIXEDLENGTH
FROM $SYSTEM.DBSCHEMA_PROVIDER_TYPES
Hi,
Did this resolve your issue ? Could we offer more help?
Hi ,
Sorry for late reply ,
While viewing the Cube via Visual Studio , I have a column lets say 'X' which has its data type as Whole Number , however using the query I get its data type as 130 , which is WCHAR , Is this expected ?
From this query:
SELECT DATA_TYPE, TYPE_NAME, COLUMN_SIZE, IS_FIXEDLENGTH
FROM $SYSTEM.DBSCHEMA_PROVIDER_TYPES
We haven't found the whole number correspondent type index. But I test in my local tabular cube, it seems in my tabular model, the whole number column also have 130 index. So I believe this is a by design behavior.