SQL server: How to see tables

Question

I have VS and SQL server database engine installed in the my office PC (Both legal copies). I would like to see the tables and like to create the new tables / databases as well for learning. How to do that?
Please help me....

Answer 1

Here is a good example using SQL Server Express: http://msdn2.microsoft.com/en-us/library/ms233763(vs.80).aspx

Greetz,

Geert

 

Geert Verhoeven
Consultant @ Ausy Belgium

My Personal Blog

Answer 2

First you need to connect to SQL Server. You can use Enterprise Manager in SQL 2000 or Management Studio in SQL 2005. First create a database, then create tables in the database. You can also use Server Explorer window in Visual studio. It is not the same and with same posibility like the one that cames with SQL Server but for creating and viewing is good enough. In VS you need again connection to SQL Server engine, and then to create database and database tables.

Answer 3

Hi,

here are some web sites for beginer tutorial , also take a look at SQL Server Books Online which will gives you idea about  everything you wants to know about SQL Server.

http://www.sql-http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

Hemantgiri S. Goswmai