sys.syscolpars
lists column names of tables, views and table-valued functions as well as parameter names of stored procedures and functions. sys.syscolpars
is a system base table, thus it needs a dedicated administrator connection to select from it. select tab.name tab_name, col.name col_name from sys.sysschobjs tab join sys.syscolpars col on tab.id = col.id order by tab.name, col.colid;