Sample Header Ad - 728x90

How to decrypt the name of columns from view?

3 votes
1 answer
337 views
I had to deal with a third-party database, I am trying to get all columns used in a view but I got them encrypted e.g: instead of getting int for NUMERO_SALARIE I got TNumSal why?
DECLARE @TableViewName NVARCHAR(128)
SET @TableViewName=N'DP_SALARIE'
SELECT b.name AS ColumnName, c.name AS DataType, b.max_length AS Length
FROM sys.all_objects a
INNER JOIN sys.all_columns b
ON a.object_id=b.object_id
INNER JOIN sys.types c
ON b.user_type_id=c.user_type_id
WHERE a.Name=@TableViewName
AND a.type IN ('U','V')
` enter image description here Is there any way to decrypt them?
Asked by TAHER El Mehdi (292 rep)
Jun 21, 2022, 07:53 AM
Last activity: Jun 21, 2022, 09:01 AM