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 vote205 views1 answer
Postgres statistics
SQL
0 vote191 views1 answer
Drop all tables db2
SQL
5 votes152 views1 answer
Copy table from one database to another mysql
SQL
0 vote195 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
36 votes216 views3 answers
Add column in mysq
SQL
0 vote215 views1 answer
Create view in sql server that contain multiple select statements
SQL
2 votes196 views1 answer
Update trigger
SQL
1 vote286 views1 answer
How to select random rows from a table
SQL
41 votes294 views6 answers
Alter table add column in SQL Server
SQL
7 votes209 views1 answer
Oracle reset sequence
SQL