[Oracle] DESCRIBE Command to Check Table Definition

Tadashi Shigeoka ·  Sun, March 4, 2012

In Oracle DB, the command to display table definitions is DESCRIBE.

DESCRIBE tablename

By the way, to check table definitions in other databases, you execute the following commands respectively:

■ MySQL

desc tablename;

■ PostgreSQL

\\d tablename

That’s all from the Gemba regarding database table definition commands.

【References】

全ては時の中に… : 【Oracle】表定義をDESCRIBEコマンドで確認する