SELECT INTO Statement drop table

-

 

SELECT INTO Statement

This SQL Server tutorial explains how to use the SELECT INTO statement in SQL Server (Transact-SQL) with syntax and examples.

Description

The SQL Server (Transact-SQL) SELECT INTO statement is used to create a table from an existing table by copying the existing table's columns.

It is important to note that when creating a table in this way, the new table will be populated with the records from the existing table (based on the SELECT Statement).

 

SELECT id,name

INTO nrdata1(new table )

FROM nrdata (old table )

WHERE sal>500;

 

 

DROP TABLE Statement

This SQL Server tutorial explains how to use the DROP TABLE statement in SQL Server (Transact-SQL) with syntax and examples.

Description

The SQL Server (Transact-SQL) DROP TABLE statement allows you to remove or delete a table from the SQL Server database.

 

DROP TABLE employees;

 

Comments

Post a Comment

Popular posts from this blog

Joining Assignment , Insert into select , database backup

-
  create   table salesman ( salesman_id   int , name varchar ( 500 ), city varchar ( 500 ) , commission int   );     create   table customer ( customer_id   int , cust_name varchar ( 500 ) , city varchar ( 500 ), grade int , salesman_id   int );     create   table orders ( ord_no int , purch_amt   int , customer_id int , salesman_id int ) create   table orders ( ord_no int , purch_amt   int , customer_id int , salesman_id int , ord_date varchar ( 20 ))     insert into salesman values ( 101 , 'Ramesh' , 'Nagpur' , '12.23' ) insert into salesman values ( 102 , 'suresh' , 'pune' , '15.23' ) insert into salesman values ( 103 , 'mahesh' , 'delhi' , '16.23' ) insert into salesman values ( 104 , 'raj' , 'pune' , '16.23' ) insert into salesman values ( 105 , 'rahul' , 'mumbai' , '17.23' )     ...
Read more

Komal Student Notes

-
  .net framework framework is a collection of tools and library which is used to applications development .net environment 1) programming environment 2) web environment 3) window environment 1) programming environment programming environment is represent console programming (c#) 2)web environment is represent using asp.net with c# 3) window environment :local application only software c# programming language :programming is a seris of valid step types of programming there are two types of programming language  1) code based programming language 2) form base    1) code based:-depend on code(c, c++, java etc)    2) form base :- based on tools(.net framework, android studio) programming environment user--->compiler(1.group 2.gives syntex error)---->interpriter(1.step by step 2.gives logical error) c# pure object oriented programming language 2) object oriented programming is based on class and object 3) structure of c#    header--->using ...
Read more

SQL SERVER SETTING

-
Image
  Sql server   notes another thing you should consider is maybe you installed sql server express edition. in this case you must enter ".\sqlexpress" as server name. or   .   dot only CREATE NEW TABLE  
Read more