Skip to content

Instantly share code, notes, and snippets.

@dafma
Created October 24, 2017 22:31
Show Gist options
  • Save dafma/eecd0aecc5e59152ba96b37f1f91f892 to your computer and use it in GitHub Desktop.
Save dafma/eecd0aecc5e59152ba96b37f1f91f892 to your computer and use it in GitHub Desktop.
buscar un campo dentro de todas las tablas en una base de datos
select sysobjects.name,sysobjects.xtype,syscolumns.*
from syscolumns, sysobjects
where syscolumns.id = sysobjects.id and
sysobjects.xtype = 'U' and
syscolumns.name = 'Moneda'
order by sysobjects.name
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment