Sql describe

-- As the name suggests, DESCRIBE is used to describe something. Since in database we have tables, that’s why we use DESCRIBE or DESC(both are same) command to describe the structure of a table.
Syntax:

DESCRIBE one;
  OR
DESC one;
-- Note : We can use either DESCRIBE or DESC(both are Case Insensitive).

-- Suppose our table whose name is one has 3 columns named FIRST_NAME, LAST_NAME and SALARY and all are of can contain null values.

Similar codes

6 votes345 views1 answer
Identify primary key in oracle table
SQL
5 votes335 views1 answer
Sqlite alter table add column
SQL
0 vote336 views2 answers
Create fulltext index mysql
SQL
0 vote430 views1 answer
Compare strings lexicographically in sql
SQL
0 vote326 views1 answer
How to close external sql connection in laravel
SQL
0 vote776 views2 answers
Zsh: command not found: mysq
SQL
1 vote333 views1 answer
Pentaho + pasar de excel a sql
SQL
1 vote317 views1 answer
Postgres format date in select
SQL
2 votes336 views1 answer
SELECT INTO
SQL
4 votes334 views2 answers
Mysql alter table set column unique
SQL