using the following query lists only the columns that are acessible to the user. If the user does not have permission on a column it will not be displayed. But I want a query to display all column names irrespective of the user has any permissions to modify or select.
Originally Posted by pootle flump
Have a peak at the INFORMATION_SCHEMA tables in BoL - terribly useful.
WHERE TABLE_NAME = 'MyTable'