How to Find Columns Particular Table in sql

Jayakumars
Posted by Jayakumars under ASP.NET AJAX category on | Points: 40 | Views : 657
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

Comments or Responses

Login to post response