how can I creae a table and update it's relationships at the same SP?

[royc75]

Hello,

I would like to create a Stored Procedure which will create a table then update it's indexes and relationships.
The problem is that when I write the CREATE TABLE and afterwards the ALTER TABLE it doesn't compile since the Table doesn't exist. So how can I creae a table and update it's indexes and relationships at the same stored procedure? A code example could be helpful...

 

[jbenson001]

Try putting a GO between the statements..

Create Table...
GO

Alter Table...

GO

 

[royc75]

I tried, doesn't work...

 

[jbenson001]

They try creating an SP to create the table, then call another sp that alters the table.

 

[royc75]

I assume that will work, but I have many Alters to do and I don't want to create different SP for each one. Isn't it possible to do in one SP?

 

[jbenson001]

just create one procedure that does all the alters. I can't see another way to do it one proc.