Skip to main content

Posts

Showing posts with the label size of table in teradata

Sql to find space occupied by a table in a specific database

          Select                     Databasename  ,Tablename                    ,Sum(Currentperm)/(1024*1024*1024)  (Decimal(15,6))  As Table_Size          From                        DBC.Tablesize         Where Databasename = ‘xyz_db‘                   And Tablename=’xyz_Table_Name’         Group By 1,2 ;