<div>
You can get the table names by:<br />
SELECT name FROM sysobjects WHERE xtype = 'U'<br />
<br />
You could then put this into a cursor and at each step, create a dynamic SQL alter table statement using the table name and execute.<br />
<br />
Chris
</div>


You can get the table names by:
SELECT name FROM sysobjects WHERE xtype = 'U'

You could then put this into a cursor and at each step, create a dynamic SQL alter table statement using the table name and execute.

Chris

<div>
Thanks Chris,<br />
Your script works perfectly!
</div>


Thanks Chris,
Your script works perfectly!

<div>
<div class="content wysiwyg-content">
I have been asked to add the same 2 columns (CUID and LUID) to every table in a database and script these changes. I am currently modifying each table one by one and copying the resulting change script into the final upgrade script. However, since there are 253 tables it will take a while to do every one! So, I am wondering if there is a faster/simpler way to do this - I am wondering if there is some kind of FOREACH statement I could use which would call the SQL ALTER TABLE function for each.
</div>
</div>


I have been asked to add the same 2 columns (CUID and LUID) to every table in a database and script these changes. I am currently modifying each table one by one and copying the resulting change script into the final upgrade script. However, since there are 253 tables it will take a while to do every one! So, I am wondering if there is a faster/simpler way to do this - I am wondering if there is some kind of FOREACH statement I could use which would call the SQL ALTER TABLE function for each.

Adding the same columns to every existing table in a SQL database

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.