WebFeb 3, 2015 · SELECT TableName FROM DBC.COLUMNS WHERE DatabaseName = 'DB_NAME' and ColumnName in ('col1', 'col2') But surely subquery must be used to get … WebLoading Application... Tracking Consent PDFs Site Feedback Help
Check User Access on Teradata
WebDec 26, 2024 · As mentioned in article Useful DBC (Data Base Computer) System Views in Teradata, DBC views can be used to check the data distribution of each table. SELECT * FROM DBC.TableSizeV WHERE DatabaseName='TestDb' AND TableName='test_table'; The above code snippet returns the data distribution of table test_table in TestDb … WebOct 31, 2024 · SELECT DatabaseName, TableName, RowCount, LastCollectTimeStamp FROM DBC.TableStatsV WHERE IndexNumber = 1 AND DataBaseName NOT IN ( 'All', 'Crashdumps', 'DBC', 'dbcmngr', 'Default', 'External_AP', 'EXTUSER', 'LockLogShredder', 'PUBLIC' , 'Sys_Calendar', 'SysAdmin', 'SYSBAR', 'SYSJDBC', 'SYSLIB', 'SystemFe', … mount office supplies
Security, access, and operations for Teradata migrations
WebOct 31, 2024 · SELECT UserName, CreatorName, DefaultDatabase, CreateTimeStamp, TRIM (TRAILING ',' FROM XMLAGG (R.RoleName ',' ) ( VARCHAR ( 255 ))) AS Roles FROM DBC.UsersV U LEFT JOIN DBC.RoleMembersV R ON U.Username = R.Grantee WHERE U.Username NOT IN ( 'TDPUSER', 'Crashdumps', 'tdwm', 'DBC' , … Web/* The following query will show the size of the tables in the DBC database in order to determine the table (s) that got too large */ LOCK dbc.tablesize ACCESS SELECT … WebOct 31, 2024 · Teradata view contains a lot of useful information about current sessions. Using SessionInfoV view Query SELECT SessionNo, UserName, ClientIpAddress, ClientProgramName, ClientSystemUserId, ClientOsName, CASE Transaction_Mode WHEN 'A' THEN 'ANSI' WHEN 'T' THEN 'TDBS' END AS TransactionMode, CurIsolationLevel … mount of gods gui