SQL statement for getting all columns of table

Hi,

What is SQL statement for getting all columns of database table ?

Thanks.

Hi Abhi,



Select * from tablename

* means all columns from a particular table.


If you need to show all columns with their structure then go for the below query.


SELECT * FROM INFORMATION_SCHEMA.COLUMNS



Thanks

Hi,

You can write the query as follows:

select *
from your_db_tableName

Here, select * means you are selecting all the columns from the given database table mentioned in from clause.

Thanks

Hi
   Showing all columns of databse table:-
If you own the table:
select column_name from user_tab_columns
where table_name = 'YOUR TABLE NAME HERE';

If you don't own the table but were granted access to it:
select column_name from all_tab_columns
where owner = 'TABLE OWNER HERE'
and table_name = 'YOUR TABLE NAME HERE';