Wyszukaj w bazie

How to find out the Tables a column name appears in

Hint Ref: 021112140002
Hint Date: 14/12/2011

Hint Details:

Lets say we were looking for all the tables with column names that contained the word 'Document' - simply open SQL Tool and execute the following SQL:

 

select table_name, column_name from systable join syscolumn where column_name like '%document%';


(Please Note: This Procedure can be destructive and should only be used by Advanced Users.  RADical Systems (UK) Limited or its Partners cannot be held responsible, in anyway, for any consequence of using this or any other Database Function, Procedure, XML Script or SQL command.  Responsibility resides solely with the user.  

IT IS HIGHLY RECOMMENDED THAT A FULL AND VALID SPACE MANAGER DATABASE BACKUP IS TAKEN AND VERIFIED AS VALID BEFORE MAKING ANY CHANGES TO THE DATABASE.)