Schema

[qsac]

does anyone know where the schema is kept? What tables?

thanks,
Q

 

[ptheriault]

qsac,
Can you be little more specific? Which schema?


- Paul
- Database performance looks fine, it must be the Network!

 

[mrdenny]

If you need to look at the schema, from SQL 7 and up you can look in the INFORMATION_SCHEMA views. In SQL 2005 you can also look in the system views (sys.tables, sys.columns, sys.procedures, etc).

If you are looking for the SQL 2005 schemas they are in sys.schemas.

If this doesn't answer your question can you be a little more specific as to what schema you are referring to?

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com