Add and Remove Columns

Question

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Chandra Sekhara Vyas Dhara SSChampion Points: 10207 More actions · Answer 1

You can write down as script and schedule the same in a job.

vaibhav.tiwari SSCommitted Points: 1976 More actions · Answer 2

You can create a temporary table and insert all the table names in that and use dynamic query for that.

Vaibhav K Tiwari
To walk fast walk alone
To walk far walk together

Paul_Harvey Hall of Fame Points: 3822 More actions · Answer 3

Hall of Fame

Points: 3822

March 29, 2010 at 3:59 am

I am sorry... but I don't know what you mean.

:ermm:

Paul_Harvey Hall of Fame Points: 3822 More actions · Answer 4

Ah I see. Ok thanks.

Is it possible that you could show me an example such a query?

vaibhav.tiwari SSCommitted Points: 1976 More actions · Answer 5

Can you go by below -

IF EXISTS ( SELECT 1 FROM sys.objects WHERE Object_ID = OBJECT_ID('tempdb..#tablename') )

BEGIN

DROP table #tablename

END

CREATE table #tablename (name varchar(100))

GO

INSERT INTO #tablename

SELECT 'table1'

UNION ALL

SELECT 'table2'

UNION ALL

SELECT 'table3'

DECLARE @sql AS VARCHAR(MAX)

SET @sql = ''

SELECT @sql = @sql + ' ALTER TABLE ' + name + ' DROP COLUMN col1 ' FROM #tableName

EXEC ( @sql )

Vaibhav K Tiwari
To walk fast walk alone
To walk far walk together

Paul_Harvey Hall of Fame Points: 3822 More actions · Answer 6

Thank you for your swift reply.

I will give this a try.

Paul

Paul_Harvey Hall of Fame Points: 3822 More actions · Answer 7

Thank you very much Vaibhav K T

That did the trick swiftly and accurately. It must have saved me hours.

:-):-)

vidya_pande SSCertifiable Points: 5275 More actions · Answer 8

This code is not having loop to alter all the tables you want.

Please check the code logic.

Alter statement should be fired for each table

vidya_pande SSCertifiable Points: 5275 More actions · Answer 9

Sorry!! its working- giving all statements in one line.