Hi All

I have a simple but annoying problem. Our vendor supplies use with a
database with 170 tables. The database is primarily driven from a
customer table with a char(15) contact_code which is the primary key.
This contact_code can be used throughout many of the 150 tables but
the field is not always labeled contact_code.

Can I write a script that returns all the table and fields that are
char(15) and owned by the administrator?

Thanks in advance

Regards

Roger

On Mar 26, 4:51*am, Roger Peffers <rpeff... (AT) gmail (DOT) com> wrote:
You can use "SELECT * from sys.syscolumn c, sys.systable t WHERE
c.table_id = t.table_id AND t.creator = user_id('Administrator')' and
c.width = 15"

However I'm not certain how to get the actual type of the column
unless it's a user defined type. In 11 at least column_type appears
to be either C for a computed column or R for other columns. Maybe
someone else has the answer to that.