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

3 votes109 views1 answer
Set default today mysql
SQL
4 votes149 views1 answer
How to check last gather stats on table in oracle
SQL
0 vote115 views1 answer
Delete duplicate rows
SQL
22 votes120 views3 answers
Year format in date mysql
SQL
1 vote118 views1 answer
List all triggers in SQL Server
SQL
0 vote110 views1 answer
Sql server select record with max id
SQL
1 vote120 views1 answer
Trim leading zeros in sql
SQL
1 vote100 views1 answer
$query = mysqli_query($con, $sql); while ($row = mysqli_fetch_array($query))
SQL
-1 vote133 views5 answers
Operator in sql
SQL
3 votes109 views2 answers
Mysql create timestamp column
SQL