hi
I have post the code How to Find Columns Particular Table in sql.
How to Execute
======================
Exec sp_SelectCols 'Test'
How To Create Stored Procedure
=================================
Create proc sp_SelectCols
@ename varchar(40)
as
Select TABLE_CATALOG,TABLE_NAME,COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS where Table_name=@ename