Tabela de Catálogo Oracle/Postgres/DB2/Firebird/MySql

Citação de Kindrazki em 15 de dezembro de 2012, 16:18

Tabela de Catálogo Oracle/Postgre/DB2/Firebird/MySql

[code]
ORACLE:
SELECT * FROM ALL_TABLES WHERE TABLE_NAME LIKE 'CADPRODUTOCUSTO%'

ORACLE - colunas
select * from USER_TAB_COLUMNS where table_name = '% %'
[/code]

[code]
POSTGRES:
select count(*) as QTDTABLE from pg_tables where tablename = 'usuarioobs'
[/code]

[code]
DB2
select count(*) as QTDTABLE from syscat.tables where tabname = 'usuarioobs'

Triggers: SYSCAT.TRIGGERS

Procedures: select routine_name,cast(routine_definition as varchar(32000)) from SYSIBM.ROUTINES where upper(routine_name) like '%PROMO%'

syscat.CHECKS
syscat.TABCONST

[/code]

[code]
FIREBIRD

Somente tabelas:
SELECT RDB$RELATION_NAME FROM RDB$RELATIONS;

Somente Views:
SELECT RDB$RELATION_NAME,RDB$VIEW_SOURCE FROM RDB$RELATIONS WHERE NOT RDB$VIEW_BLR IS NULL and rdb$relation_name = 'VSALDOANALITICA'

[/code]

[code]
MYSQL
SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'xxx'
[/code]

[code]
SQL SERVER

SELECT TABLE_NAME, COLUMN_NAME, COLUMNPROPERTY(OBJECT_ID(TABLE_SCHEMA + '.' + TABLE_NAME), COLUMN_NAME, 'ColumnID') AS COLUMN_ID
FROM AdventureWorks2008R2.INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'Person'

[/code]