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')
Is there any way to decrypt them?