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

2 votes326 views1 answer
Drop table if exists in postgres
SQL
15 votes330 views3 answers
Find duplicate keys in mysql
SQL
0 vote350 views2 answers
Update information in a mysql column
SQL
5 votes342 views4 answers
Rollback to in sql
SQL
0 vote327 views1 answer
Composit key in sql
SQL
4 votes328 views1 answer
Sql query to make a existing column auto increment
SQL
1 vote322 views2 answers
Mysql spring boot application.properties
SQL
6 votes327 views2 answers
Mysql first day of month
SQL
3 votes316 views1 answer
Index using in query plsql
SQL
0 vote335 views1 answer
Get yesterday date ISO in psql
SQL