[SQL]实现Oracle拷贝表Create table as select
来源:互联网 发布:python使用turtle 编辑:程序博客网 时间:2024/06/07 22:25
Transact-SQL 拷贝表
在做数据迁移的时候会经常复制表,或者只复制表结构,在ORACLE下可以使用:create table as select...,但是在SQLServer下这种语法是错误的。
--Oracle下语法:
create table BranchAccount as select * from TATA.dbo.BranchAccount
--SqlServer下语法:
select * into BranchAccountfrom TATA.dbo.BranchAccount
注:本文原创由`bluetata`发布于blog.csdn.net、转载请务必注明出处。
阅读全文
0 0
- [SQL]实现Oracle拷贝表Create table as select
- oracle create table xx as select ....CREATE TABLE XXX AS SELECT .... 拷贝表的时候 not null 约束 和check
- oracle create table as select
- Oracle Create Table as Select
- Create table as select
- create table as select
- oracle数据迁移--复制表--create table as select & select into & insert into
- 浅谈create table as select
- Using CREATE TABLE AS SELECT (CTAS) to Reorganize Oracle Tables
- Oracle中,使 CREATE TABLE AS SELECT 支持ORDER BY
- ORACLE CTAS(create table as select)使用注意点
- ORACLE CTAS(create table as select)使用注意点
- oracle数据库【表复制】insert into select from跟create table as select * from 两种表复制语句区别
- postgres create table as select & create table like
- MySql create table ... as select * from ..
- Select into from 与 Create Table As
- create table as select性能测试
- sqlserver不能直接create table as select ......
- vc版run as (指定用户运行)
- 解决继承HibernateDaoSupport用getHibernateTemplate()无法更新的问题
- 动态规划题目
- Linux_06 Linux其他命令
- JS中splice跟slice的区别
- [SQL]实现Oracle拷贝表Create table as select
- 对象无法注入
- 非常可乐 HDU
- 并查集与欧拉回路
- On the way
- T-SQL 编程小结 (SQL Server)
- [TensorFlow 学习笔记-06]激活函数(Activation Function)
- [leetcode]: 345. Reverse Vowels of a String
- javaeeeclips快速开发 快捷键