Posts by GUILHERME PAGLIONI • 1 point
2 posts
-
0
votes1
answer68
viewsA: SQL ALTER TABLE
I was able to solve the problem as follows IF (SELECT COUNT(COLUMN_NAME) AS resultado FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'procedimentos_planos_tratamentos' AND COLUMN_NAME = 'tipo')…
-
0
votes1
answer68
viewsQ: SQL ALTER TABLE
I need to make some changes in my bank, but before adding a new column I need to check if it already exists, if there is no create new column if there is no column then create Command found to check…