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

0 vote139 views1 answer
Mysql does collate nopad recognize space
SQL
1 vote151 views1 answer
SQL Integer devision
SQL
24 votes145 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
SQL
2 votes137 views1 answer
Oracle calculated column
SQL
0 vote153 views1 answer
Sql select column name like from multiple tables
SQL
0 vote138 views2 answers
Homebrew nysql launch
SQL
1 vote132 views1 answer
Launch sql script from docker in mysql
SQL
0 vote152 views1 answer
Oracle flush Shared Pool
SQL
0 vote148 views1 answer
Postgresql delete limit
SQL
1 vote144 views2 answers
Mysql extract month
SQL