create existing table

(Component Integration Services only) Creates a proxy table, then retrieves and stores metadata from a remote table and places the data into the proxy table. Allows you to map the proxy table to a table, view, or procedure at a remote location.

The preferred method of creating proxy tables is the create proxy_table command, which eliminates the need to define the column definitions.

Syntax

create existing table table_name (column_list) 
	[on segment_name]
	[[external {table | procedure | file | connection_type}] at pathname 
	[column delimiter "string"]]

Parameters

Examples

Usage

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

create existing table permission defaults to the table owner and is not transferable.

Related reference
alter table
create table
create proxy_table
drop index
insert
order by clause
set
update