Stored Procedure that returns the number of Schemas that database has

• ernesto.felix.city

  SSC Enthusiast

  Points: 170

  More actions

  October 26, 2012 at 5:23 pm

  #266129

  Also, it neeeds to return the schema names along too..!

  Its an assignment for school but Im having difficulty understanding what I need to do.

  I know there are some system views involved correct? Some joining among DMVs?

  It needs to be in a stored procedure. Can someone give me some tips on how i can go about this...AdventureWorks has schemanames (not dbo), so will this make it more complicated?

  Thank you

  Ernesto

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  October 26, 2012 at 5:33 pm

  #1553455

  You can find that information in these links

  For the schemas:

  http://msdn.microsoft.com/en-us/library/ms182642.aspx

  http://msdn.microsoft.com/en-us/library/ms176011.aspx

  For the stored procedure:

  http://msdn.microsoft.com/en-us/library/ms187926.aspx

  I'll give you a tip: use google or even better press F1

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2