Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Conver to Sybase Query to SQL Query

2 posts in General Discussion Last posting was on 2005-02-09 10:40:05.0Z
karunakar Posted on 2005-02-09 09:28:43.0Z
From: "karunakar" <karunakarraop@stcroixsystems.com>
Newsgroups: ianywhere.public.general
Subject: Conver to Sybase Query to SQL Query
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Original-NNTP-Posting-Host: 203.115.124.42
Message-ID: <4209d7c7@forums-2-dub>
X-Original-Trace: 9 Feb 2005 01:28:39 -0800, 203.115.124.42
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 9 Feb 2005 01:28:40 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 9 Feb 2005 01:28:43 -0800
X-Trace: forums-1-dub 1107941323 10.22.108.75 (9 Feb 2005 01:28:43 -0800)
X-Original-Trace: 9 Feb 2005 01:28:43 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4120
Article PK: 8007

Hi All

Please convert this Query

Sybase To SQL :

Syabse Query :

SELECT "sys"."systable"."table_name" "TABLE" , "sys"."systable"."count" from
"sys"."systable"
WHERE ("sys"."systable"."creator"=1) order by "sys"."systable"."TABLE_NAME"

Regards
Karunakara Rao.


Breck Carter [TeamSybase] Posted on 2005-02-09 10:40:05.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Conver to Sybase Query to SQL Query
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <bvpj01htm8bubkqrm2ha64kiiihp1frdo6@4ax.com>
References: <4209d7c7@forums-2-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 208.254.244.99
X-Original-NNTP-Posting-Host: 208.254.244.99
Date: 9 Feb 2005 02:40:05 -0800
X-Trace: forums-1-dub 1107945605 208.254.244.99 (9 Feb 2005 02:40:05 -0800)
X-Original-Trace: 9 Feb 2005 02:40:05 -0800, 208.254.244.99
Lines: 37
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4121
Article PK: 8002

Do you mean "Microsoft SQL Server"? It is really important to know
what product you are asking about, since the system catalog tables are
different for every product.

FWIW the query shows the table names and row counts for all tables
owned by the DBA user id.

Breck


On 9 Feb 2005 01:28:43 -0800, "karunakar"

<karunakarraop@stcroixsystems.com> wrote:

>Hi All
>
>Please convert this Query
>
>Sybase To SQL :
>
>Syabse Query :
>
>SELECT "sys"."systable"."table_name" "TABLE" , "sys"."systable"."count" from
>"sys"."systable"
>WHERE ("sys"."systable"."creator"=1) order by "sys"."systable"."TABLE_NAME"
>
>Regards
>Karunakara Rao.
>
>
>

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com