Search
 
SCRIPT & CODE EXAMPLE
 

SQL

show the colums of table sql

SHOW COLUMNS FROM table_name;

or 

DESCRIBE table_name;
Comment

PREVIOUS NEXT
Code Example
Sql :: update query with between in mysql 
Sql :: mysqldump ignore table 
Sql :: oracle select first result 
Sql :: how to show index type in postgresql 
Sql :: get number of table colums in sql query 
Sql :: oracle pagination query offset 
Sql :: how to drop all tables in sql 
Sql :: replace null in sql 
Sql :: mysql date range 
Sql :: date conversion in mysql column 
Sql :: update auto increment value in mysql 
Sql :: split string from comma in sql 
Sql :: oracle get running queries 
Sql :: plpgsql create function 
Sql :: sql check duplicate value in column 
Sql :: myswql show full processlist 
Sql :: do postgresql 
Sql :: add colum date in sql 
Sql :: sql counter column 
Sql :: change filed order in mysql 
Sql :: postgresql delete limit 
Sql :: mysql grant all on all databases 
Sql :: postgres duplicate key value violates unique constraint already exists 
Sql :: change user mysql password 
Sql :: reset auto increment mysql 
Sql :: osx stop mysql service 
Sql :: query distinct 
Sql :: groupby error in mysql 
Sql :: sql cnvert bit to nvarchar 
Sql :: oracle insert into where 
ADD CONTENT
Topic
Content
Source link
Name
3+7 =