requete oracle :Table/Champ

Sur une bd Oracle

• Recherche d’un champ à partir d’un motif

Select TABLE_NAME, COLUMN_NAME from USER_TAB_COLUMNS where COLUMN_NAME like '%'

•  Recherche d’une table à partir d’un motif

SELECT * FROM user_tables where table_name like '%'

Sur Sql Server

 

select TB.name [table], C.name [champ], T.name [type],
from sysobjects as TB
join syscolumns as C on TB.id=C.id
join systypes as T on C.xtype=T.xtype
where    TB.xtype='U'
and     T.name like '%'
order by TB.name, C.name