Skip to main content
T
tbaggz
Participant
October 18, 2006
質問

Understanding SQL Database

  • October 18, 2006
  • 返信数 2.
  • 337 ビュー
I have recently inherited a application that has a MS SQL backend to it. I am new to SQL, is there any friendly view in SQL that will allow me to look at the tables contents and columns? There are about 50 tables and i didnt know if MS SQL had an easy way to view it and understand it, to see what kind of information is in each table. Or if anyone with some experience with MS SQL has had this similar situation, any help is greatly appreciated. I am going to continue to try and solve the problem on my own and I will post if i do.
Thanks a lot
Drew
このトピックへの返信は締め切られました。

返信数 2

S
Sankalan
Participating Frequently
October 18, 2006
Please install MS SQL.
If you are new to MS SQL, there are basically three things that will help you most:

1. Books Online:
Start--Programs--Microsoft SQL Server--Books Online
You can find all the help files here.

2. Enterprise Manager:
Start--Programs--Microsoft SQL Server--Enterprise Manager
You can see all databases, tables of databases, design and data view of tables.

3. Query Analyzer:
Start--Programs--Microsoft SQL Server--Query Analyzer
You can write and run queries, stored procedures etc using this. This is just like Query Browser in MySql.

Hope this will be of your help.

Thanks

Sankalan
(www.mindfiresolutions.com)
M
mcsenow
Participant
October 18, 2006
You can install MS SQL Client and then use the Enterprise Manager tool
Firefly Community Gallery
Adobe Firefly

Remix with Firefly Community Gallery

Thousands of free creations to fall in love with and remix in Firefly.

Explore now
契約条件Accessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices