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 vote209 views1 answer
Postgresql alter table sequence
SQL
0 vote216 views1 answer
Plpgsql create function
SQL
0 vote189 views1 answer
Delete a record from a table sqlite3
SQL
2 votes192 views3 answers
Oracle show column of table
SQL
3 votes177 views1 answer
Mysql insert on dupèlicate
SQL
0 vote228 views1 answer
Insert query return id mysql
SQL
7 votes160 views3 answers
Sql get last inserted row
SQL
1 vote169 views1 answer
Sql convert month name to number
SQL
0 vote199 views1 answer
Postgresql concat string with separator
SQL
0 vote164 views1 answer
Set column in all row mysql
SQL