salix/db/routines/vn2008/views/Impresoras.sql

10 lines
325 B
MySQL
Raw Permalink Normal View History

CREATE OR REPLACE DEFINER=`root`@`localhost`
SQL SECURITY DEFINER
VIEW `vn2008`.`Impresoras`
AS SELECT `vn`.`printer`.`id` AS `Id_impresora`,
`vn`.`printer`.`path` AS `Ruta`,
`vn`.`printer`.`name` AS `Impresora`,
`vn`.`printer`.`reference` AS `referencia`,
`vn`.`printer`.`isLabeler` AS `isLabeler`
FROM `vn`.`printer`