CODEWITHSUNDEEP
sqloracle-databaseteradata
ricov07
ricov07

Reputation: 3

problems with DESCRIBE statement in oracle sql developer using JDBC driver

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?

Upvotes: 0

Views: 1514

Answers (1)

access_granted
access_granted

Reputation: 1907

Try this:

SHOW TABLE $database.$table

Upvotes: 1

Related Questions