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

New Contributor

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 anyone kindly clarify what this means?  I intrepret this to mean creating tables and views using SQL scripts.  An online video demonstration of creating a table without using the build in tools, however, shows creating tables and views using SQL Server's menu options.


Any help would be very much appreciated!

2 Replies
best response confirmed by Daniel Schperberg (New Contributor)

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"

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



    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!