sp_servercaps system procedure

Displays information about a remote server’s capabilities.

The server must be defined with the CREATE SERVER statement to use this system procedure.

sp_servercaps servername

DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.

Sybase IQ uses capability information to determine how much of a SQL statement can be forwarded to a remote server. The system tables that contain server capabilities are not populated until after Sybase IQ connects to the remote server. This information comes from syscapability and syscapabilityname system tables. The servername specified must be the same server name used in the CREATE SERVER statement.

Displays information about the remote server testiq (output has been truncated):

sp_servercaps testiq

1,’Alter table with add’,’T’
2,’Alter table with drop’,’T’
3,’Owner supported’,’T’
4,’Primary key requires index’,’F’
5,’Create table constraints’,’T’
6,’Truncate table’,’T’
7,’Create index’,’T’ 7,’Create index’,’T’
8,’Create unique index’,’T’
9,’Syscapability system table initialized’,’T’
10,’Subquery’,’T’
11,’Subquery in group by’,’T’
12,’Subquery in comparison’,’T’
13,’Subquery in exist’,’T’
14,’Subquery in IN’,’T’
15,’Subquery correlated’,’T’
16,’Subquery in select list’,’T’
17,’Subquery in update’,’T’
20,’Order by’,’T’
21,’Order by expressions’,’T’
22,’Order by column not in select list’,’T’
23,’Order by allowed in update’,’T’
25,’Joins’,’T’
26,’Outer joins’,’T’
27,’Full outer joins’,’T’
28,’Multiple outer joins’,’T’
29,’Logical operators in outer join’,’T’
30,’Outer joins mixed with normal joins’,’T’
31,’ANSI join syntax’,’T’
32,’TSQL join syntax’,’F’
33,’ODBC outer join syntax’,’F’
34,’Unrestricted ANSI ON’,’T’
40,’Group by’,’T’
41,’Group by ALL’,’T’
45,’Aggregates’,’T’
46,’Aggregates with column name’,’T’
50,’And’,’T’
51,’Or’,’T’
52,’Like’,’T’
53,’Like - TSQL’,’T’
54,’Distinct’,’T’
55,’In’,’T’