Board index » delphi » get all USER DEFINED DATA TYPE

Alberto Kalb

Delphi Developer
Mon, 12 Sep 2005 21:56:45 GMT

get all USER DEFINED DATA TYPE

how can I get all USER DEFINED DATA TYPE and for everyone get the table name
where it is used using MS SQL 2000 ???

Thanks a lot,
Alberto

 
Peter Jene

Delphi Developer
Tue, 13 Sep 2005 01:44:42 GMT

Re:get all USER DEFINED DATA TYPE


Check out systypes table, sp_tables and sp_columns system stored procedures
in Books Online.

Peter Jenei

Quote
"Alberto Kalb" <akalb....@tiscalinet.it> wrote in message

news:3e83030d$1@newsgroups.borland.com...
Quote
> how can I get all USER DEFINED DATA TYPE and for everyone get the table
name
> where it is used using MS SQL 2000 ???

> Thanks a lot,
> Alberto

Other Threads

1. HELP user defined data types

2. how get all USER DEFINED DATA TYPE from MSSQL 2000 DB

3. Firing events to a container with user defined data types

4. Corba: type Any and user defined types..

5. TEdit..Display user defined Types

6. IDE - User-defined types in units with non-visual functions

7. Passing User Defined Types to a Procedure

8. publish user-defined property types ?

9. User defined types...Help

10. Oracle stored procedure parameters of user-defined type