Forum Discussion

Daniel Schperberg's avatar
Daniel Schperberg
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 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!

  • Christian Araujo's avatar
    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's avatar
    Christian Araujo
    Copper Contributor
    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's avatar
      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!

Resources