Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 INFORMIX SQL QUERY

Author  Topic 

grajesh_955
Starting Member

5 Posts

Posted - 2008-08-08 : 03:44:54
Hi Guys:

I am trying to create a table by copying from another table without copying its data by using the query...
create table old_f1304a as (select * from f1304a WHERE 1=0)

But its showing error.
201: A syntax error has occurred..

Can you guys suggest how to do that...

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-08-08 : 03:51:48
informix? you do know this a MSSQL Server forum?

Em
Go to Top of Page

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-08-08 : 03:53:20
oh, apparently you do know...
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=103015

Em
Go to Top of Page

grajesh_955
Starting Member

5 Posts

Posted - 2008-08-08 : 04:17:45
Sorry guys..for putting the query in this forum...If you know any answers plz suggest me some thing...
Go to Top of Page
   

- Advertisement -