Archives of the TeradataForum

Message Posted: Wed, 09 Jan 2008 @ 13:25:00 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: DDL ( Show Table ) from DBC tables

From:		Anomy Anom

<-- Anonymously Posted: Wed, 9 Jan 2008 11:13 -->

In reply to : -

How do we get the "Show Table" output from DBC tables ? Our users do not have rights to do a "Show Table". Is there a way I can get the original CreateText from DBC tables ?

Try SHOW SEL * FROM TABLE/VIEW;

This will provide the DDL

Rgds


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Archives

2008		2003
2007		2002
2006		2001
2005		2000
2004		1999

2008 Indexes

Jan		Jul
Feb		Aug
Mar		Sep
Apr		Oct
May		Nov
Jun		Dec


	Top	Home	Join	Privacy	Feedback

Copyright for the TeradataForum (TDATA-L), Manta BlueSky

Last Modified: 01 Dec 2008