Archives of the TeradataForum
Message Posted: Fri, 30 May 2003 @ 21:33:08 GMT
Maybe BTEQ does something to the Query... I just ran it from Queryman and it does not return an error.
(My system has no entries in DBC.All_RI_Children but that should make no difference to a syntax error.)
Rather than build statements like this and then execute them you might find it easier to use a Queryman (SQL Assistant) Import statement.
First switch on Export, and run a simple Select statement as:
select DISTINCT CHILDDB, CHILDTABLE, INDEXNAME
This exports the results to a text file.
Use Notepad (or whatever) to remove the column headers from this file.
Then switch on Import mode and run the query:
ALTER TABLE ?.? DROP CONSTRAINT ?;
When it asks for the Import file point it to the file created by the export above.
In this particular case it may not be that much simpler ... but for more complex Queries it can make things much simpler. (Especially if the data already exists in a delimited text file. For example creating a whole bunch of UserIds for a new application group.)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|