how can i see all the scheme in the sql server 2000

Question

Possible Duplicate:
How do I obtain a list of all schemas in a Sql Server database

I manage to see all the schemas in the sql server 2000. I used the following statement

show search_path

But it failed.

Answer 1

Please try:

SELECT * FROM INFORMATION_SCHEMA.SCHEMATA

For more info please refer link How do I obtain a list of all schemas in a Sql Server database