Archives of the TeradataForum

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

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

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>>