Search
 
SCRIPT & CODE EXAMPLE
 

SQL

create table with select

CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl;
Comment

create table as select * from table mssql

  Select * into new_table  from  [database].[schema].[old_table] 
Comment

PREVIOUS NEXT
Code Example
Sql :: how to change the value of a table in sql 
Sql :: insert if not exists postgresql 
Sql :: creer une base de donnée psql 
Sql :: sql random integer 
Sql :: oracle exceeded simultaneous sessions_per_user limit 
Sql :: get last week data in mysql 
Sql :: how to export table data from mysql table in sql format 
Sql :: docker run mysql image 
Sql :: how to pass password mysql command line 
Sql :: postgresql allow remote connection 
Sql :: how to search date in sql query 
Sql :: view t-sql mail configuration 
Sql :: clear a table in mysql 
Sql :: postgres autoincrement primary key 
Sql :: mysql remove duplicates 
Sql :: select all_source oracle 
Sql :: sql delete caracter list 
Sql :: delete record mysql query 
Sql :: how to use lower case in mysql 
Sql :: find duplicates mysql 
Sql :: round one decimal place mysql 
Sql :: sql trim all spaces 
Sql :: sql limit results returned 
Sql :: sql identity column reset 
Sql :: how to unlock table in sql server 
Sql :: is not numeric sql 
Sql :: DB: in eloquent using sql 
Sql :: create a view in sqlite 
Sql :: 3 days back in sql server 
Sql :: if else in postgresql 
ADD CONTENT
Topic
Content
Source link
Name
2+6 =