problems with DESCRIBE statement in oracle sql developer using JDBC driver

0
votes

I just set up a teradata JDBC database through Oracle SQL Developer. I can't get the 'DESCRIBE' command to work, or the 'HELP TABLE' command (usually the case with teradata).

If I put in DESCRIBE tablename ; I get error:

[Teradata Database] [TeraJDBC 14.10.00.26] [Error 3706] [SQLState 42000] Syntax error: expected something between the beginning of the request and the word 'DESCRIBE'.

If I use HELP TABLE tablename ; it gives me a help menu internal to Oracle sql developer

Anyone else have this issue? or know any alternatives to the DESCRIBE command?

1
sqloracleteradata
DESCRIBE is an oracle command. I would not expect it to work with a different database. - OldProgrammer

1 Answers

1
votes

Try this:

SHOW TABLE $database.$table