SQL statement for getting all columns of table

Question

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

Datta Kharad · Answer

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';

sheetal · Answer

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

Satyapriya Nayak · Answer

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