var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Find all column names from Table
I have 1 table it contains some no of columns but i need a query to know list of column names in that table.
exec sp_help tablename
Originally Posted by MCrowley
Thank yo very much your query helped me but i just want column names only.
can u help me.
select * from syscolumns where id = (select id from sysobjects where xtype='u' and name ='<table name>')
WHERE table_name = 'table_name'
SELECT name As column_name
WHERE object_id = Object_ID('table_name')