Archives of the TeradataForum

Message Posted: Wed, 30 Jul 2003 @ 13:56:33 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Sanjaya,

SELECT
 'SHOW '||(CASE WHEN (TABLEKIND = 'T') THEN 'TABLE'
             WHEN (TABLEKIND = 'P')  THEN 'PROCEDURE'
             WHEN (TABLEKIND = 'V')  THEN 'VIEW'
             WHEN (TABLEKIND = 'M') THEN 'MACRO'
END)||' '||TRIM(DATABASENAME)||'.'||tablename||' ;'
FROM dbc.tables
WHERE DATABASENAME = :DBNAME  AND
          TABLENAME LIKE :TBNAME ;

Srini

	<Prev	Next>		<<First	<Prev	Next>	Last>>