[RESOLVED] Stored Procedure

[Abbas Haider]

Hi

I need to design a stored procedure which returns the names of the all field.
Be it in T-SQL or PL-SQL.

Thanks in Advance

[GaryMazzone]

The SQL will be very different in both of these databases

[Abbas Haider]

Give me in T-Sql please,
That will be very kind of you

[si_the_geek]

Thread moved to Database Development forum - which is where SQL questions belong

You will presumably want to extend this a bit, but here is a starting point:

SELECT * 
FROM Information_Schema.Columns

You could also use the existing system Stored Proc sp_columns, eg:

sp_columns 'table1'

[Abbas Haider]

Thanks si
Thanks a lot