Constancia icon

SQL_SYS_ELIMINAR_AGREGAR_COLUMNA

Constancia | PRO | 02/05/14 06:21:27 AM UTC | 0 ⭐ | 214 👁️ | Never ⏰ | []
PL/SQL |

410 B

|

None

|

0 👍

/

0 👎

Raw Download Clone Embed Print View 
-- *************** ELIMINAR COLUMNA
IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '[TABLA]' AND  COLUMN_NAME = '[COLUMNA]')
BEGIN
    ALTER TABLE [TABLA] DROP COLUMN [COLUMNA]
END
 
-- *************** AGREGAR COLUMNA
IF  NOT EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '[TABLA]' AND  COLUMN_NAME = '[COLUMNA]')
BEGIN
    ALTER TABLE [TABLA] ADD [COLUMNA] INT NULL
END

Comments