how to join existing table with table created by "create existing table"
"create existing table" can help to create a table which is
linked to a sp select selection.
but can this table be join to other physical tables?
Yes, proxy tables can be used in joins.
> "create existing table" can help to create a table which is
> linked to a sp select selection.
> but can this table be join to other physical tables?
but i cant, pls refer my example below:
create procedure po_t1 (@p1 char(8) )
CREATE EXISTING TABLE t1
(ret_out1 datetime not null, ...Proxy tables
I am trying to use proxy tables in a 6.0.3 environment. I've run the
following statements successfully from my machine on a local db:
CREATE SERVER 'ptest' CLASS 'ASAODBC' USING 'mydsn';
CREATE EXISTING TABLE table1p at 'ptest...table1';
This works fine. Now, a co-worker tries to do this on his machine
against his database and gets the following error when executing the
CREATE EXISTING TABLE statement on his db:
'Java virtual machine could not be started'
So, I decide to try to connect to his db and try it myself, issuing the
e...create table statement not creating table
This is a multi-part message in MIME format.
Version ASA9.0.1 build 1964
I have a script that I apply to our databases to add tables, triggers, =
stored procedures,... using dbisqlc.
When I run the script on a particular database 3 tables are not getting =
created properly. I am not seeing any errors in the isql.txt file =
created by dbisqlc regarding the table create, but later when I try =
adding triggers on the new tables I receiv...Create table hangs but table was created
18.104.22.168 on Solaris.
In a Java application, we create small tables on the fly
"create table MyTable (id char(20) NOT NULL)". It's been
there for quite a while. Then in the middle of one day,
every time it hangs there. We then tried it on isql, same
behavior. Then we found that even though the call didn't
return, the table was actually created on the database. This
lasted for about two hours. Then it went back to normal
behavior. Could anyone think of what might have caused it?
...Create Table and Alter table:
I am using SQl server studio management to create table.
How to set two attributes as a primary key: composite key. like ( proj_id, emp id) both as primary key.
How to specify the forign key constraint. using alter table
Please give me the example: don't syntax which msdn gives.
Thanks and Regards
Hi,Look at this. 1 CREATE TABLE Menu
3 MenuId int,
4 Title varchar(50),
5 Url varchar(256),
6 ParentId int NULL
9 ALTER TABLE Menu ADD CONSTRAINT MenuId PRIMARY KEY
...Create new Table from existing table
I'm trying to Create a new Table from existing table in Q/Analyzer. I figured it would be something like this:
CREATE TABLE newTable AS(SELECT * FROM OldTable);
but i keep getting
Server: Msg 156, Level 15, State 1, Line 1Incorrect syntax near the keyword 'AS'.
also.. is there another method of doing this, something like
INSERT INTO newTable(SELECT * FROM OldTable);
and it creates the table ( newTable ) for u if it doenst already exist??
im using sql2000
You can try this one:
SELECT * INTO newTable FROM OldTableLimno
The easiest method to copy ...How to create a table with copying everything from an existing table
I would like to create a table that is identical to an existing table
(table definitions, structures, and data itself). In Oracle, the
following command will do the work:
create table new_table as select * from existing_table;
But in Sybase, it seems there is no such command to do the job. Is there
any way to do it?
Thanks for your help.
There is command:
select * into new_table from existing_table
This will work.....go ahead
Xiaobing Suo <firstname.lastname@example.org> wrote in message
> I would like to create a table t...Cannot create an SP that creates a table that already exists
If the temporary table zzsummary already exists and I try to create the
below SP I get -
Error: There is already an object named 'zzsummary' in the database.
(State:S0001, Native Code: A9A)
Why is this?
Also, if I delete the table, add the SP, run apex_LoadChqSavSummary "Pre",
and then apex_LoadChqSavSummary "Post", I get -
Error: Object 'zzsummary' cannot be found.
(State:S1000, Native Code: 10B)
CREATE PROCEDURE apex_LoadChqSavSummary @mode varchar(5)
BEG...Create Dynamic Table and Insert values to it from existing table
Need some help with the sql statement for this one. I want to create a dynamic table and then after that I will insert data into that created table from an existing table. It's like making a back up of a certain table on my database.
I really appreciate any help from you guys. Thanks.
select * into <DestinationTableName> from <SourceTableName>The above query will create a new table with the name specified as <DestinationTableName> and populate the data from the <SourceTableName> in it.The ideal way of doing this would be to:First create a t...chg of domain drops/creates table
Having rev.eng. an ASE 12.5 database to PD9,
I'm structuring the PDM with new domains.
However when modifying the DB, PD insists on
1) adding new domain
2) creating tmp-table
3) move data to tmp table, drop table
4) create new table, move data from tmp-table, drop tmp-table
5) recreating index, fk, whatever...
Why on earth doesn't it just do an alter table?
(ie: add new domain, alter table )
This is the generalist approach. You can intelligently look at the base
data type of the column and the new domain ...Reverse Engineer created copies of table (table:1, table:2)... How do I merge them back into 1 table?
I just reverse-engineered about 20 tables from our database, and it took
one of my key tables and created two copies ("TableName : 1" and
"TableName : 2"). I'm sure the engine was trying to make the diagram
easier for it to auto-layout, but I want all the FKs and such from one
table). How do I merge them back into just one table?
Jason Vogel wrote:
> PowerDesigner 12.1
> I just reverse-engineered about 20 tables from our database, and it took
> one of my key tables and created two copies ("Tabl...How to creat table as excel table
I'm a cambodia student and now i'm stilling do a reserche and auto-study in c# langage. I have a question to all people interes in this forum,
Bye ussing C# and asp.net application form how coud i creat a table as excel table, that alow to edit information in cells as we use excel.
form spheaStudent in cambodia
I suppose that the best way is to create xml file, but older Excel's versions doesn't support xml.http://blogs.msdn.com/brian_jones/archive/2005/06/27/433152.aspx
Regards,...Create table creates identity
I have this script to create a table but when I run the table is created but
there is the identity column that gets created that I don't want. How can I
get this to stop?
create table dbo.inventory_usage (stock_number char(50) not null,
cur_yr_jan decimal(10,2) null,
cur_yr_feb decimal(10,2) null,
cur_yr_mar decimal(10,2) null,
cur_yr_apr decimal(10,2) null,
cur_yr_may decimal(10,2) null,
cur_yr_jun decimal(10,2) null,
cur_yr_jul decimal(10,2) null,
cur_yr_aug decimal(10,2) null,
cur_yr_sep decimal(10,2) null,
cur_yr_oct decimal(10,2) null,
cur_yr...Creating a Table from another Table.
I need to be able to create a temporary table that is exactly like an
existing table. In Oracle, the syntax to do this was as follows:
CREATE TABLE NEWTABLE AS (SELECT FROM EXISTINGTABLE);
This effectively copies the table structure and creates a table called
newtable that is
a "clone" of the existing table.
How can this be accomplished in SQLA, short of writing a stored
procedure or a function?
Thanks for your response.
Consolidated Services Corp
SELECT * INTO NewTable FROM OldTable
Jaguar Product Team
Owen Hebert wrote: