SQL command for showing columns

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.

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

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