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 vote140 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL
0 vote189 views1 answer
Ms sql print more than 1 variable
SQL
14 votes145 views4 answers
Remove record from table sql
SQL
27 votes173 views3 answers
Mysql show tables in database
SQL
1 vote186 views3 answers
Date_add mysql
SQL
0 vote155 views1 answer
Import mysql'
SQL
1 vote153 views1 answer
Increasing font and zooming in mysql workbench
SQL
0 vote155 views1 answer
Query to get all primary keys and foreign key
SQL
9 votes159 views3 answers
Find all tables with column name
SQL
0 vote142 views1 answer
Mysql regex exact match
SQL