February 24, 2011 at 5:41 am
Due to sql auditing and conttrol issues imposed within our organisation, I am developing a front end process (away from SQL Query Analyzer) that will allow SQl queries to be written, run, audited and saved, whilst preventing any unauthorised accesses to be made.
Generally, this looks to be do-able but I am now looking at creating a treeview list of tables/views/functions etc to mimic the list of objects that is displayed in SQL Query Analyser.
However, I have notice an issue with the sysname type. I am currently extracting column information directly from the INFORMATION_SCHEMA.Column table and have noticed that sysname seems to be nvarchar(128). However, we also have valid nvarchar types that are not sysname. How do I identify which columns are sysname and which should remain as nvarchar in my treeview list (i.e. is there a join I need to do somewhere to find out this info)?
February 24, 2011 at 8:33 am
Actually, it may well be I need to ask an even more basic question:
Is there a general sql stored procedure or other sql process that lists all database objects in a similar way to the Object Browser in the SQL Query tool?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply