WebJun 13, 2024 · 5. select * from dbc.tablesv. where. CreatorName='Revisit_User1'. and databasename = 'Banking_DB'. and Tablekind = 'T'; The above query will fetch the all the tables created by User Revisit_User1 in the database Banking_DB. The TableKind field specifies the kind of object as T (table), V (view), P (stored procedure) or M (macro). http://www.forgetcode.com/Teradata/1533-How-much-space-are-your-tables-using
Find the time when table was last accessed in …
WebApr 12, 2024 · Sodium cyanide is a highly toxic and water-soluble inorganic compound with the chemical formula NaCN. It is a white solid that is used mainly in the mining industry to extract gold and other ... WebJul 26, 2024 · This page shows how to use LIKE in Teradata to check whether a string column contains, starts with or ends with certain characters. All the code snippets are using string literal and you can replace them with your table/view column name if you want to apply them in your queries. Starts with a string. We can use % to match a chdk careers
How to find all the tables created by specific user in Teradata?
WebApr 12, 2024 · Disodium phosphate, also known as sodium hydrogen phosphate, is a salt of phosphoric acid with the chemical formula Na2HPO4. It is a white, odorless powder that is commonly used as a food additive ... WebOct 31, 2024 · List tables by their size in Teradata database. Bart Gawrych ... table_size - space used by table in MB; Rows. One row represents one table in a database; Scope … WebOct 18, 2014 · The Teradata Partitioned Primary Index aims to keep the records of a table packed together in clearly delineated containers. There are not too many in total about the table’s size. In that sense, partitioning is a different way … chdk forum