How to Use Describe Command in Sql
Connect to the database and navigate to the Object Explorer. For example for Delta tables you can see the current reader and writer versions of a table. How To Use Group By Having And Order By Sql Clauses Dummies The metadata information includes column name column type and column comment. . The DESC is the short form of DESCRIBE command and used to dipslay the information about a table like column names and constraints on column name. Optionally a partition spec or column name may be specified to return the metadata pertaining to a partition or column respectively. For a list of tables in the current schema use the Show Tablescommand. If you do use SQL Developer or Toad they have a feature where you bring up a table and it gives you the SQL not PLSQL - that is not needed plain and very fast SQL is all thats needed to re-create the. To control the width of the data displayed use the SET LINESIZE command. This may give unex...