SQL Tutorial - 10: Creating Tables from Other Tables

In this tutorial we'll learn to use the CREATE TABLE statement to create a table using a preexisting table in the database.

Hope you guys had fun watching the tutorial!

[AditiBhondwe]

Great video !!! You've really explained the topic in detail!

[BabbanTantrik]

I enjoyed the way of explanation.
Thank you very much Sir.

[sumeetsapla]

i m not able to create table table from other table in microsoft SQL server help me out it is giving the error:incorrect syntax near select

[bashar]

Hi Madhur, I have tried doing this exact word for word in SQL server 2012,
getting following message 'Incorrect syntax near the keyword 'select'.'

from what I read on the internet some SQL commands are no supported in different DBMS such as SQL server is this true?

also the DESC command does not work in SQL server 2012

[aanaysingh]

can i create a view using other tables too?

[imly]

Hi, Madhur, I tried to use same syntax but not working the error showing at 'select' and also DESC not working

[thelegitimatenoob]

I had fun being the 49, 101th person watching this

[raghubarua]

Madhur, Thanks for the nice tutorials.. Can we also have some advance level tuts for comparision of different DBMS flavors to widen the knowledge.

[krishnakishoreg]

Hi Madhur, ,
I quick question here .. When we create copy of columns, will its properties also be copied . I observed that "id" is primary key in employee table and it is not in emp_info table .. One more question, I see apart from id column others are showing yes for null. What does that mean

Thanks
krishna

[kaushikjammy]

Great tutorials are these set of tutorials enough to gain sufficient knowledge in SQL?

[subbudgreat]

Hi Madhur,
I have a query, for the employee table the primary key constraint is present, but when we are creating a new table form emp_info and importing the columns id, name we are not getting the primary key constraint for id in the new table emp_info, is there a reason why this is not coming?

[asfandkhan]

i m using sql 12..they give me error when i execute this query.. error is incorect syntex near kwyword AS

[akshayathale]

Hi,
Why we are getting "int(11)" in the result when running DESC employyee, even we have not specify any limit.

Akshay

[aanandingle]

Who's watching this vid in 20222????

[shwethagowda]

Hi,
After executing queries, i am not getting outputs.

[sireeshareddy]

Can you provide real time interview questions in SQL

[bellasun]

thx~
however, hope you could provide the code and tables.

[vasugoel]

brother can you send me the link to download that software

[monaduttasangita]

sir why your tutorial name is bad that you have specified clearly to