Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 31 Jul 2003 @ 12:08:13 GMT


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


Subj:   Re: User/Database DDL
 
From:   Anil Thapak

hi,

This SQL will not return ddl statement but you can get all the neccessary information related with database.

Select          databases.Databasename,
                databases.ownername,
                databases.Accountname,
                databases.ProtectionType,
                case  substring(journalflag from 1 for 1)
                              when 'n' then 'No Before Journal'
                              when 's' then 'Single Before Journal'
                              when 'd' then 'Dual before Journal'
                 End as BeforeJournalType,
                 case  substring(journalflag from 2 for 1)
                              when 'n' then 'No After Journal'
                              when 's' then 'Single After Journal'
                              when 'd' then 'Dual After Journal'
                  End as AfterJournalType,
                  databases.PermSpace,
                  databases.spoolspace,
                  databases.tempspace,
    database_Default_journals.JournalName

from            dbc.databases inner join dbc.database_Default_journals
  on dbc.databases.databasename = database_Default_journals.databasename
where          dbc.databases.databasename = 'YourDatabaseName';

Regards

Anil Thapak



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023