Add Column to existing table in SQL Server

[fmvizcaino]

Hello community,

I'm trying to find a way of adding a new column to a existing table in sql server, is there an easy way? Easier than using alter table in a pre sql statement.

Thanks,

Fernando Vizcaino

[tcroberts · Accepted solution]

Is there a particular reason you're adverse to adding a pre-SQL "ALTER TABLE" statement? It's probably the quickest and safest way to do so.

[fmvizcaino]

It is a dynamic workflow that distributes 20k rows x 20k columns file into a bunch of different SQL tables. Since we are having some performance issues, I was wondering if there was a way of not inserting one more possible bottleneck to the process.

But if it's the easier way, I'm gonna use it.

Thanks a lot tcroberts,

Fernando Vizcaino