SQL command for showing columns

Question

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

Jignesh Trivedi · Answer

Hi Try this.. select c.name [Column Name]o.name [Table Name] from sys.all_columns c sys.objects o where o.object_id = c.object_id and o.type='U' hope this help.

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

Dhaval Patel · Answer

Dear Alok For all column of database table use this query SELECT Table_Name Column_Name Data_Type Is_Nullable FROM information_schema.columns WHERE table_name IN (SELECT name FROM sysobjects WHERE xtype='U') ORDER BY table_name Thanks & Regards Dhaval Patel