Archives of the TeradataForum

Message Posted: Thu, 02 Oct 2003 @ 11:29:25 GMT


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

Subj:		Re: Importing file into bteq query

From:		Dieter Noeth

Ferry, Craig wrote:

I can't use the CREATE TABLE as syntax because I want to be able to change the primary index on the fly (I didn't find a way to do this with CREATE TABLE).

Create table new_tab as existing_table with no data primary index(colx);

Be aware that all secondary indexes will be dropped when you specify any index.

Dieter


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

Archives

2016		2007
2015		2006
2014		2005
2013		2004
2012		2003
2011		2002
2010		2001
2009		2000
2008		1999

2003 Indexes

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

Last Modified: 15 Jun 2023