This is a discussion on management tool express 2005 within the SQL Server forums, part of the Microsoft SQL Server category; --> It there a way to view tables in 2005 express edition? I know I can write a query but ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| It there a way to view tables in 2005 express edition? I know I can write a query but I seem to recall seeing the ability to bring up a table view - though it was on the full SQL server edition. If not, is the a commercial tool? Will 2008 express provide this functionality? Thanks, Alex |
| ||||
| You should be able to right click on a table and select Open Table. But it is much better to use the Query window to select from the table. The graphical table tools are really not the best way. Just add a BIT column to one table and see if you can type 0 or 1 in the open table screen (and those are supposed to be the values for BIT data type). -- Plamen Ratchev http://www.SQLStudio.com |
| Thread Tools | |
| Display Modes | |
|
|
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| SQL 2005 Management Studio/Express - Any differences | John Fox | SQL Server | 2 | 09-12-2008 05:23 PM |
| SQL 2005 Express | =?Utf-8?B?R2VuZQ==?= | MS SQL ODBC | 2 | 08-15-2008 03:23 PM |
| Newbie on permissions: ADO.NET, C++.NET, SQL SERVER 2005 EXPRESS, Visual Studio 2005 | raylopez99 | SQL Server | 9 | 03-01-2008 02:47 PM |
| Management Studio Express | Maury | SQL Server | 1 | 02-29-2008 07:54 PM |
| MS SQL 2005 Express | Jassim Rahma | SQL Server | 3 | 02-29-2008 08:16 AM |