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

1 vote125 views1 answer
Oracle user last connected
SQL
2 votes113 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote129 views1 answer
Download mysql database to excel in android studio
SQL
1 vote116 views1 answer
Oracle aleter trigger ora-01031
SQL
1 vote126 views1 answer
Mysql get domain from url
SQL
0 vote130 views2 answers
How to generate a unique random number in mysql
SQL
0 vote123 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
0 vote124 views1 answer
Sql server select record with max id
SQL
1 vote130 views1 answer
Oracle update with sequence
SQL
2 votes131 views2 answers
Create empty table from existing table
SQL