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

4 votes258 views2 answers
Postgre sql create table
SQL
0 vote261 views1 answer
Could not assemble any primary key columns for mapped table sqlalchemy
SQL
-1 vote287 views1 answer
Pl/sql how to delete a trigger
SQL
1 vote214 views1 answer
Ms sql how to see active job current run time
SQL
0 vote314 views1 answer
How to rename a database in tsql
SQL
9 votes247 views2 answers
Get first 3 letters in sql
SQL
2 votes275 views1 answer
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote245 views1 answer
Mysql create table like
SQL
0 vote261 views1 answer
Oracle temporary table
SQL
1 vote253 views1 answer
Sql to mongodb query converter
SQL