View the contents of a table in a SQL Server database using Enterprise Manager?

Open Enterprise Manager and expand the registered SQL Server

Expand Databases

Expand the database

Click on Tables, all of the tables in the database will show up in the right pane

Locate the table you’d like to open, right-click it and select Open Table -> Return Top…

Type the number of rows you would like to view, click OK

If you would like to view all rows in the table, select the Return All Rows option.

  • 11 Utilizadores acharam útil
Esta resposta foi útil?

Artigos Relacionados

Manage Database Roles

Solution Database roles are conceptually completely separate from operating system users....

Manage Tablespaces

Tablespaces in PostgreSQL allow database administrators to define locations in the file system...

ColdFusion DSN parameters are not updated

SYMPTOMS New CF DSN records are created.  Even the set of parameters is tried to be updated...

Finding what packages are installed on a Linux system

For distributions that use RPM format packages, use the command: $ rpm -qa You may want to pipe...

What platforms does Linux support?

Linux runs on almost every general-purpose computer made in the last 10 years. It runs on systems...