Hi,
I'm using Vista and i have some issue that i need to know in order to do it efficiently in Ms SQL server 2008.
I have an excel/word file with all the tables name in a column along their attributes on the next column. There's around 300 tables and around 6000 row of attributes. Btw, i have all the real tables created already along the attributes(SMAL L CAPS), each of these attribute's data type, allow null is set already. I just want to rename the attributes(SMAL L CAPS) in the table from the source/excel file i have now to BIG CAPS attributes.( i have done already in the excel file).
Question: Is there any method that i can do this without RENAME/TYPING it 1 by 1 into the MSSQL?
Big Thanks.
Regards,
Darrenovic
I'm using Vista and i have some issue that i need to know in order to do it efficiently in Ms SQL server 2008.
I have an excel/word file with all the tables name in a column along their attributes on the next column. There's around 300 tables and around 6000 row of attributes. Btw, i have all the real tables created already along the attributes(SMAL L CAPS), each of these attribute's data type, allow null is set already. I just want to rename the attributes(SMAL L CAPS) in the table from the source/excel file i have now to BIG CAPS attributes.( i have done already in the excel file).
Question: Is there any method that i can do this without RENAME/TYPING it 1 by 1 into the MSSQL?
Big Thanks.
Regards,
Darrenovic
Comment