an equivalent to MySQL 'Show' in SQLServer

Is there an equivalent command in Microsoft's SQLServer 2008 to the Show command in MySQL?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Aaron TomoskyDirector of Solutions ConsultingCommented:
There is no direct equivalent.  SHOW is a metadata command in MySQL that, if pushed for an answer, be best related to a combination of the sys schema objects, Dynamic Management Views, and DBCC commands in SQL Server 2005 and above.  That is not even a close approximation for equivalent functionality.

Some examples

SHOW DATABASES -> select .. from master.sys.databases
SHOW COLUMNS -> select .. from information_schema.columns (ANSI alternative to "from sys.columns")

In some cases, other custom solutions are required, such as SQL Server

sp_lock - show lock information
sp_who - processes (or go to master.dbo.sysprocesses)
select * from fn_helpcollations() - SHOW collation

In other cases, the SHOW command is MySQL specific relating to its engine or way of doing things

SHOW MUTEX STATUS -- innodb mutex stats
SHOW WARNINGS -- there are uncommon SQL Server methods to read the log file for the last entry

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
makingitbigAuthor Commented:
It seems this is the best one can get with the lack of a 'ShOW' command in MSSQL.  Has anyone written an 'add-on' to mimic SHOW or is that even possible with a proprietary implementation of SQL?
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.