#DateForumTypeThreadPost
1101 Jun 2009 @ 05:14 PDTDatabaseReplyQuery to find out the table name and the columns of that table associated with a viewThat's really a surprise that teradata does not store this information in any dbc tables.I would have to write an entire sql parser for this reason or customize an open source sql parser to suite m...
1029 May 2009 @ 08:56 PDTDatabaseTopicQuery to find out the table name and the columns of that table associated with a viewCan we frame a query to find out the original table name and the original column names of that table associated with a teradata view.I was unable to figure out, what dbc tables/view are to be used ...
903 May 2009 @ 02:04 PDTDatabaseReplyHow do we find whether the Teradata database being used is a 64 bit or a 32 bit using SQL?Hi guys,I just figured out that there is a column named platform in dbc.tvm table. That will be useful in finding out which platform the database is installed on, for example Suse,mpras,etc.I came ...
829 Apr 2009 @ 05:54 PDTDatabaseTopicHow do we find whether the Teradata database being used is a 64 bit or a 32 bit using SQL?Does any one know how to find out, whether the Teradata database being used is a 32 bit machine or a 64 bit machine, using TD SQL?
724 Apr 2009 @ 11:20 PDTDatabaseReplyWill there be any space overhead for every column in a Teradata Table row based on its datatype?Thanks a ton. This is exactly what I wanted.
624 Apr 2009 @ 08:15 PDTDatabaseTopicWill there be any space overhead for every column in a Teradata Table row based on its datatype?Will there be any space overhead for every column in a Teradata Table row based on its datatype?
524 Apr 2009 @ 06:36 PDTDatabaseReplyWhat is the best way to calculate the tablespace manually.But, I also need to know the size occupied by each column. How do i get that?
415 Apr 2009 @ 05:09 PDTDatabaseTopicWhat is the best way to calculate the tablespace manually.I know that we can get the space occupied by a table using the following sql : SELECT sum(CurrentPerm) FROM DBC.TableSize WHERE DatabaseName = 'dbname' and tablename = 'tname';What is the best way,...
315 Apr 2009 @ 04:50 PDTDatabaseReplycorresponding teradata query for a oracle queryThe following sql will give you the DDL for the table : show table tablename ;The following will give you the table description :help table tablename;Hope this helps !!
214 Apr 2009 @ 08:07 PDTDatabaseReplyHow do we find the typical/average space occupied by column on disk?Thanks a ton maddy. Your idea really helped.
114 Apr 2009 @ 02:33 PDTDatabaseTopicHow do we find the typical/average space occupied by column on disk?I know we can get the max length of a column.But when it comes to datatypes like varchar, etc where it is not necessary that it occupies all the bytes allotted to it, how do we calculate the averag...