SQL server: How to see tables
-
Saturday, January 13, 2007 8:22 AMI 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....
All Replies
-
Saturday, January 13, 2007 9:48 AM
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 -
Saturday, January 13, 2007 4:55 PMFirst 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.
-
Wednesday, January 17, 2007 9:06 AMModerator
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.aspHemantgiri S. Goswmai

