All Forums Database
SJ11 1 post Joined 06/13
29 Jul 2015
How to get the statement that was used to create a table in Teradata?
dnoeth 4628 posts Joined 11/04
29 Jul 2015

SHOW TABLE mytable;

Dieter

M.Saeed Khurram 544 posts Joined 09/12
29 Jul 2015
SELECT REQUESTTEXT FROM DBC.TABLES
WHERE TABLENAME LIKE '%MYTABLE%';

 

Khurram

dnoeth 4628 posts Joined 11/04
29 Jul 2015

Hi Khurram,
this might return "create index" or "alter table" if the table definition was modified after creation.

Dieter

dianaazura 1 post Joined 07/15
30 Jul 2015

if the table definition was modified after creation create index

You must sign in to leave a comment.