| Breck Carter [TeamSybase] 2005-09-05, 1:26 pm |
| Like sa_db_properties, except the result set includes only
DB_EXTENDED_PROPERTY
values where the "property-specific argument" is
meaningful; i.e., FileSize, FreePages, DBFileFragments extended
properties. The result set would also include the property-specific
arguments; i.e., all the dbspace names:
CREATE PROCEDURE sa_db_extended_prope
rties (
in dbidparm integer default null )
result (
Number integer,
PropNum integer,
PropName varchar(255),
PropDescription varchar(255),
PropArgument varchar(255), -- or long varchar, for the future?
Value long varchar )
This is needed as a "builtin procedure" so it can be referenced as a
proxy procedure; currently there is no way to retrieve
DB_EXTENDED_PROPERTY
values from a remote database without actually
creating a user-written procedure or view on that database to be
called via a proxy... some folks allow proxy access but not actual
schema changes.
Breck
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
|