无法访问SQL表 [英] Can't access SQL table

问题描述

我是SQL新手所以我正在尝试做一些基本的事情。



我用SQL Managment Studio 2016创建了一个表，它有属性：名称：测试

数据库名称：测试和架构：dbo。



我正在尝试练习简单的SQL语句，但我无法访问我的表。

I am new to SQL so I am trying to do some basic things.

I created a table with SQL Managment Studio 2016 and it has properties: Name:test
Database Name: Testing and Schema: dbo .

I am trying to practice simple SQL statements but I can not access my table.

SELECT*FROM .....

关于。 ...地方，我试过写dbo.test / test / Testing.test但我似乎无法达到它。



另外，我想知道如何创建更多的行而不仅仅是列，因为我正在使用图形创建器而不是用语句编写它们。



我尝试了什么：



我尝试使用CREATE语句创建一个新的，但它的工作原理只是因为我从网上获取了一个好的代码。

On the .... place, I have tried writing dbo.test/test/Testing.test but I can not seem to reach it.

Also, I would like to know how can you create more rows and not only columns as I am using the graphic creator and not writing them with statements.

What I have tried:

I tried creating a new one with CREATE statement and it works but only because I took a good code from the web.

推荐答案

在SQL Management Studio中，右键单击数据库并选择新建查询。在显示的窗口中：

In SQL Management Studio, right click the database and pick New Query. In the window that shows up:

SELECT * FROM test

或

Or

SELECT * FROM Testing.dbo.test

FROM子句通常是 FROM database.schema.table 。

确保您的查询窗口已连接到数据库服务器并使用

Make sure your Query window is connected to database server and use

Select * from Testing.dbo.test

如果已经创建了表，这将有效。

this will work if table is already created.

这篇关于无法访问SQL表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！