请问sybase里怎么列举所有视图？

anjx

免费乐捐，感谢支持

我现在知道怎么用SQl语句列举表了，可以用：select object_name(id),rowcnt(doampg) from sysindexes where indid=0

但是谁能告诉我怎么列举视图和索引吗？谢谢！

 

yunnet23

select name from sysobjects where type='U'
//查询当前数据库中的所有表

select name from sysobjects where type='P'
//查询当前数据库中所有的Stored procedure

select name from sysobjects where type='V'

//查询当前数据库中所有的View

yunnet23

sysobjects (T-SQL)

Contains one row for each object (constraint, default, log, rule, stored procedure, and so on) created within a database. In tempdb only, this table includes a row for each temporary object.

Column name	Data type	Description
name	sysname	Object name.
Id	int	Object identification number.
xtype	char(2)	Object type. Can be one of these object types: C = CHECK constraint D = Default or DEFAULT constraint F = FOREIGN KEY constraint L = Log P = Stored procedure PK = PRIMARY KEY constraint (type is K) RF = Replication filter stored procedure S = System table TR = Trigger U = User table UQ = UNIQUE constraint (type is K) V = View X = Extended stored procedure
uid	smallint	User ID of owner object.
info	smallint	Reserved. For internal use only.
status	int	Reserved. For internal use only.
base_schema_ver	int	Count of changes in schema of a given object (incremented if a rule or default is added).
replinfo	int	Reserved. For use by replication.
parent_obj	int	Object identification number of parent object (for example, the table ID if a trigger or constraint).
crdate	datetime	Date the object was created.
ftcatid	smallint	Identifier of the full-text catalog for all user tables registered for full-text indexing, and 0 for all user tables not registered.
schema_ver	int	Version number that is incremented every time the schema for a table changes.
stats_schema_ver	int	Version number of the statistics.
type	char(2)	Object type. Can be one of these values: C = CHECK constraint D = Default or DEFAULT constraint F = FOREIGN KEY constraint K = PRIMARY KEY or UNIQUE constraint L = Log P = Stored procedure R = Rule RF = Replication filter stored procedure S = System table TR = Trigger U = User table V = View X = Extended stored procedure
userstat	smallint	Reserved.
sysstat	smallint	Internal status information.
indexdel	smallint	Index delete count (incremented if an index is deleted).
refdate	datetime	Reserved for future use.
version	int	Reserved for future use.
deltrig	int	Reserved.
instrig	int	Reserved.
updtrig	int	Reserved.
seltrig	int	Reserved.
category	int	Used for publication, constraints, and identity.
cache	smallint	Reserved.