The following syntax is used to find the table size in Teradata
Syntax: Select databasename,tablename,sum(currentperm) from dbc.tablesize where databasename='<databasename>' and tablename='<tablename>' group by databasename,tablename;
While running the above query, type your databasename in place of <databasename> and type your tablename in place of <tablename>
Syntax: Select databasename,tablename,sum(currentperm) from dbc.tablesize where databasename='<databasename>' and tablename='<tablename>' group by databasename,tablename;
While running the above query, type your databasename in place of <databasename> and type your tablename in place of <tablename>
Thanks for the blog article.Thanks Again. Keep writing.
ReplyDeleteteradata training
oracle bpm training
angular js training