Hi,
Is it possible to do from one script? We have a set of user's tables like
"tbl%". We can get this list very easy using this script:
SELECT name FROM sysobjects WHERE xtype = 'U' AND name LIKE 'tbl%' ORDER BY
name;
We need to change some column names if these names are in a special list
that we have. What can we do? Use FOR EACH ROW? Or what?
So, I need to get a column list for each table and check if every column
name is equal to one of the names from the list and then if YES replace it
by something or add some symbol to this name. Terrible or possible?
Regards,
Dmitri
Is it possible to do from one script? We have a set of user's tables like
"tbl%". We can get this list very easy using this script:
SELECT name FROM sysobjects WHERE xtype = 'U' AND name LIKE 'tbl%' ORDER BY
name;
We need to change some column names if these names are in a special list
that we have. What can we do? Use FOR EACH ROW? Or what?
So, I need to get a column list for each table and check if every column
name is equal to one of the names from the list and then if YES replace it
by something or add some symbol to this name. Terrible or possible?
Regards,
Dmitri