Constancia

SQL_SYS_ELIMINAR_AGREGAR_COLUMNA

Feb 5th, 2014
271
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.41 KB | None | 0 0
  1. -- *************** ELIMINAR COLUMNA
  2. IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '[TABLA]' AND  COLUMN_NAME = '[COLUMNA]')
  3. BEGIN
  4.     ALTER TABLE [TABLA] DROP COLUMN [COLUMNA]
  5. END
  6.  
  7. -- *************** AGREGAR COLUMNA
  8. IF  NOT EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '[TABLA]' AND  COLUMN_NAME = '[COLUMNA]')
  9. BEGIN
  10.     ALTER TABLE [TABLA] ADD [COLUMNA] INT NULL
  11. END
Advertisement
Add Comment
Please, Sign In to add comment