[RESOLVED] Stored Procedure

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

The SQL will be very different in both of these databases

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

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:

Code:

---

SELECT *
FROM Information_Schema.Columns

---

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

Code:

---

sp_columns 'table1'

---

Thanks si
Thanks a lot