MySQL Forums
Forum List  »  Microsoft SQL Server

Advanced Search
New Topic

Re: How to Retrieve the Schema in MSSQL?
Posted by: Roland Bouman
Date: February 17, 2006 06:45PM

1) SHOW syntax (see: http://dev.mysql.com/doc/refman/5.0/en/show.html)

2) information_schema (as of MySQL 5.0.2, see: http://dev.mysql.com/doc/refman/5.0/en/information-schema.html.) This is supported in MS SQL too. (Altough there, you can also query the sys% tables)

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
How to Retrieve the Schema in MSSQL?
Henry
February 22, 2005 03:51PM
Re: How to Retrieve the Schema in MSSQL?
Perry Way
February 11, 2006 01:01PM
Re: How to Retrieve the Schema in MSSQL?
Roland Bouman
February 17, 2006 06:45PM
Re: How to Retrieve the Schema in MSSQL?
Roland Bouman
February 17, 2006 06:43PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.