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 vote297 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
1 vote305 views1 answer
Sql select whole row max column
SQL
0 vote243 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
1 vote335 views1 answer
Mysql default port
SQL
0 vote266 views1 answer
How many columns can be used for creating index?
SQL
33 votes332 views6 answers
Sql delete
SQL
1 vote286 views4 answers
Mysqldump 1 table only
SQL
1 vote239 views2 answers
Show sql logs in spring boot
SQL
3 votes301 views1 answer
Oracle list dates without weekends
SQL
1 vote289 views1 answer
Tsql find foreign key references
SQL