-
Notifications
You must be signed in to change notification settings - Fork 0
/
bigint-to-smallint.sql
27 lines (18 loc) · 986 Bytes
/
bigint-to-smallint.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
select * from empresa
select * from ferramenta_comunic
select * from linguagem_programacao
select * from pais
select * from resp_usa_ferramenta
select * from resp_usa_linguagem
select * from respondente
select * from sistema_operacional
alter table sistema_operacional alter column sistema_operacional_id type smallint;
--alter table respondente alter columns "id",sistema_operacional_id,pais_id,empresa_id type smallint;
alter table respondente alter column sistema_operacional_id type smallint;
alter table respondente alter column pais_id type smallint;
alter table respondente alter column empresa_id type smallint;
alter table resp_usa_linguagem alter column id type smallint ;
alter table resp_usa_ferramenta alter column id type smallint;
alter table pais alter column pais_id type smallint;
alter table linguagem_programacao alter column linguagem_programacao_id type smallint;
alter table ferramenta_comunic alter column ferramenta_comunic_id type smallint;