PROVE IT !!If you know it then PROVE IT !! Skill Proficiency Test

How to generate a list of tables which are FALLBACK in Teradata ?

Q 32 ) How to generate a list of tables which are FALLBACK in Teradata ?

Answer >

SELECT
DATABASENAME,
TABLENAME,
CREATORNAME,
LASTALTERTIMESTAMP,
(CASE WHEN PROTECTIONTYPE=’F’ THEN ‘FALLBACK ‘ ELSE ” END )||
(CASE WHEN JOURNALFLAG like ‘%Y%’ THEN ‘JOURNAL ENABLED ‘ ELSE ” END )||
(CASE WHEN REQUESTTEXT LIKE ‘%UNICODE%’ AND TABLEKIND=’T’ THEN ‘UNICODE ‘ ELSE ” END) AS TABLE_TYPE
FROM DBC.TABLESV
WHERE PROTECTIONTYPE=’F’ AND TABLEKIND=’T’ AND DATABASENAME LIKE <***** List the databasename for which you want to find SET Tables ****>

Add a Comment

Your email address will not be published. Required fields are marked *