Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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.
Comment

PREVIOUS NEXT
Code Example
Sql :: SQL IS NULL With COUNT() 
Sql :: 2 max value in sql 
Sql :: pl sql auto increment 
Sql :: drop database mysql 
Sql :: convert negative to positive in sql 
Sql :: having clause in sql 
Sql :: pgadmin check database 
Sql :: mysql pad zeros 
Sql :: How do I UPDATE from a SELECT in SQL Server? 
Sql :: back up stored procedures mysql 
Sql :: get specific column in mongodb 
Sql :: how to check last index rebuild sql server 
Sql :: oracle list user locked 
Sql :: procedure syntax 
Sql :: SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause 
Sql :: compress sql file database ubuntu 
Sql :: mysql error the maximum column size is 767 bytes. 
Sql :: Write an SQL query to fetch the count of employees working in the department ‘Admin’. 
Sql :: SQL Greater than () 
Sql :: mysql not null 
Sql :: postgresql populate data random 
Sql :: create column that already exists mysql 
Sql :: db count rows 
Sql :: between keyword sql 
Sql :: Oracle cx_Oracle example 
Sql :: mysql allow connection from any host 
Sql :: foreign key sql 
Sql :: sql order by clause 
Sql :: grant sql 
Sql :: mysql trigger to delete old data 
ADD CONTENT
Topic
Content
Source link
Name
9+5 =