Find out what type of Encoding was used

Question

Is there a way to find out what kind of encoding was used for a table field? I need to maintain a system, but I wanted to know if you have how to use sql server.

Answer 1

If "encoding" refers to data types, there are several ways.

You can use SQL_VARIANT_PROPERTY, when you enter "Basetype" in the parameter Property.

-- código #1
CREATE TABLE Super (Nome varchar(50), Idade smallint, Salário money);
INSERT into Super values ('Aparício', 18, 2000);

SELECT top (1) sql_variant_property (Nome, 'BaseType'),
       sql_variant_property (Idade, 'BaseType'),
       sql_variant_property (Salário, 'BaseType')
  from Super;

---

You can also use INFORMATION_SCHEMA.

-- código #2
CREATE TABLE Super (Nome varchar(50), Idade smallint, Salário money);

SELECT COLUMN_NAME, DATA_TYPE
 from INFORMATION_SCHEMA.COLUMNS
 where TABLE_NAME = 'Super';

Details in System Information Schema Views.

---

But the best way is by the visual editor of Management Studio (or another similar tool).