blob: 0fc72f8bbaacfd226ab0b82870b53825e9303515 (
plain)
1
2
3
4
|
IF ((SELECT DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'clitelefone' AND COLUMN_NAME = 'TIPO') = 'numeric')
BEGIN
ALTER TABLE [dbo].[clitelefone] ALTER COLUMN TIPO INT;
END
|