New to Sybase-Need help with Indexes

[friday]

Hi,

I'm a Siebel consultant, and am unfamiliar with Sybase. However, Siebel mobile clients have a Sybase database stored locally on their laptops. I need help with basic Sybase SQL syntax, like how to query Sybase for a list of existing tables, general table information (like
"DESCRIBE&quot, how to query for existing indexes (without knowing their names), and how to drop those indexes when found.
Any help is most appreciated.
Thanks
Friday

 

[Guest_imported]

http://manuals.sybase.com/onlinebooks/group-as/asg1200e/;pt=31612/*

 

[Tim1]

Hiya,

The easier way to look for an object in a database is

SELECT * FROM sysobjects.

For an index, you need SELECT * FROM sysindexes.

The Sybase format to drop an index is

DROP INDEX tablename.indexname.

HTH

Tim

 

[Guest_imported]

Hi,

There is a stored procedure "sp_help" which can be used to get information about the database objects like tables, indexes.

Just use &quot;sp_help <table_name>&quot;

Thanks
-Mithra

 

[qyllr]

hello,

you can also try the sybase central software...for a visual approach rather than command line...

cheers,

q.

 

[vechalapu]

Hi,

You can use sp_helpindex to see indexes for a given table name.

sp_helpindex <Table Name>