


delete from _columnas where tabla='doc_documento.alquiler'
insert into _columnas
(tabla,columna ,mostrarEnGrilla ,ordenGrilla ,requerido ,tipo,defecto ,tamano)
select 
TABLE_NAME
,COLUMN_NAME
,case when COLUMN_NAME not in('uid','eid')then 1 else 0 end
,case when COLUMN_NAME not in('id','uid','eid')then 1 else 0 end
,1
,DATA_TYPE 
,COLUMN_DEFAULT
,CHARACTER_MAXIMUM_LENGTH
FROM INFORMATION_SCHEMA.COLUMNS  where Table_Name='doc_documento.alquiler'




