Como excluir um indice...

Firebird

29/11/2005

_DM_INTERBASE.IBDatabase1.DatabaseName:= “C:\MaxProgramador\Pro Projeto\Teste\BD Interbase\BD.GDB“;
_DM_INTERBASE.IBDatabase1.LoginPrompt:= false;
_DM_INTERBASE.IBDatabase1.Params.Add(“user_name=sysdba“);
_DM_INTERBASE.IBDatabase1.Params.Add(“password=masterkey“);
_DM_INTERBASE.IBDatabase1.SQLDialect:= 3;
_DM_INTERBASE.IBDatabase1.DefaultTransaction:= IBTransaction1;
_DM_INTERBASE.IBDatabase1.Connected:= false;

_DM_INTERBASE.IBTransaction1.defaultdatabase:= _DM_INTERBASE.IBDatabase1;
_DM_INTERBASE.IBTransaction1.DefaultAction:= TACommitRetaining;
_DM_INTERBASE.IBTransaction1.Active:= false;

_DM_INTERBASE.IBQuery1.database:= _DM_INTERBASE.IBDatabase1;
_DM_INTERBASE.IBQuery1.SQL.Clear;
//DROP INDEX IND_NOME;
_DM_INTERBASE.IBQuery1.SQL.Add(“DROP INDEX IND_NOMES ON “ENDERECO_2“ ( NOME )“);
_DM_INTERBASE.IBQuery1.ExecSQL;
_DM_INTERBASE.IBQuery1.SQL.Clear;

Esta dando a mensagem linha 1 caracter 22...
Aonde estou errando...


Max.sgj

Max.sgj

Curtidas 0

Respostas

Afarias

Afarias

29/11/2005

“DROP INDEX IND_NOMES“


T+


GOSTEI 0
POSTAR