Brothersoft.comWindows|Mac|Mobile|Games

|Message

Solve software problem quickly Share experience to help others Improve the ability of solving problem
How Can I See What Tables Are Available in Query Analyzer?

10/31/2011 03:16 by maxkitty

First answer posted by JeffreyStanley at 10/31/2011 03:16
Add Your Answer
10~1000 characters in length CAPTCHA:
1 Answers
  • JeffreyStanley
    1. Open SQL Server Enterprise Manager, then expand your "SQL Server Group." Expand <server name>, then expand "Databases."

    2. Expand your database, then click the "Tools" menu. Click "SQL Query Analyzer" and type the following to view the user tables available in this database:

      select * from sysobjects where xtype='U'

    3. Type the following to view system tables available:

      select * from sysobjects where xtype='S'

    4. Press "F5" to run your query and view results.

  • Was this answer helpful? 00 · 10/31/2011 03:16
Add Your Answer
10~1000 characters in length CAPTCHA:
Related Questions
Q:How Can I See What Tables Are Available in Query Analyzer?

A: Open SQL Server Enterprise Manager, then expand your "SQL Server Group." Expand <server name>, then expand "Databases." Expand ...(more)

Q:How to Restore Joomla! From Backup?

A: Backup and restore Joomla using phpMyAdmin. The phpMyAdmin utility is typically installed by your hosting provider within their administra...(more)

Q:MySQL 5.0: Database Tutorial?

A: Install MySQL onto your machine and connect it to the server. Provide a MySQL user name and password at the prompts. When you see the "mys...(more)

Q:How to Use AJAX With Photos?

A: Download the AJAX plug-in. Log in to your Joomla account. Click on the "Installer" button, select "Components". Select the zippe...(more)

Q:How to Tutorial on MySQL Lock?

A: Open the MySQL query tool. Type a query that locks the table. For example, to prevent others from reading data while you perform your quer...(more)

Added Successfully!

×

Are you sure to delete your answer?

NoYes

×

Are you sure to choose it as the best answer?

NoYes

×

Voted Successfully!

×

You can't vote for yourself

×

You can't choose your own answer

×