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 vote360 views1 answer
What is default mysql database password in linux
SQL
21 votes375 views4 answers
Add column mssql
SQL
1 vote333 views1 answer
Foreign key in oracle sql developer
SQL
0 vote368 views1 answer
Create function in microsoft sql server
SQL
1 vote375 views2 answers
How to check if sql query is correct online
SQL
2 votes403 views2 answers
Select sqlite3.OperationalError: no such column:
SQL
4 votes338 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
0 vote366 views1 answer
Postgres read table structure
SQL
1 vote372 views1 answer
How to test for sql injection
SQL
0 vote352 views1 answer
Month mysql
SQL