Forum Discussion

Copper Contributor

Aug 30, 2017

Solved

Question on creating SQL objects "without using the built in tools".

Hi everyone! I am preparing for to take the SQL exam 70-461. In the study guide, I find the following phrase very confusing: "Create tables (and views) without using the built in tools". Could ...

Christian Araujo
Sep 28, 2017
I hope it still works, but I believe this relates to the scope of the exam "Quering" so you would be able to create objects using T_SQL in management studio not just with the "Right click, create table"

Christian Araujo

MCT

Sep 28, 2017

I hope it still works, but I believe this relates to the scope of the exam "Quering" so you would be able to create objects using T_SQL in management studio not just with the "Right click, create table"

Daniel Schperberg

Copper Contributor

Sep 28, 2017

Yes, that's what I thought. It should be as simple as saying:

CREATE TABLE (

Column1 INT,

FooBar ...

)

The training videos posted on Youtube confuses me greatly, because they use "Right-click Create table". That appears like a built-in tool to me.

Thanks for answering!