Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- *************** 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
Advertisement
Add Comment
Please, Sign In to add comment