Generate a column script

Question

I'm looking to generate a script of specific table column. How i can do that?

SQL Server 2012 allow to generate a script of a single table but not a single column.

I don't think you are asking for what you think you are asking for. The scripts you generage can CREATE a table, veiw, function, or a stored procedure. You can't make just a column. That would then be a one column table. — Zane
– Zane, Commented Nov 19, 2013 at 19:54
@Zane i'm looking to generate a create script i just want a column of the table not the complete table script. — Freddy
– Freddy, Commented Nov 19, 2013 at 20:05

David · Accepted Answer · 2013-11-19 20:16:21Z

1

There's no built in functionality to do this. In order to accomplish something like this, you would need to make a script that would go through the system tables to retrieve the information for the column then generate an ALTER TABLE [] ADD [] statement.

I do something like this with temp tables so you can see an example of what that might look like. I would note the code sample provided here is partially complete and updated whenever I encounter a corner case it doesn't cover already.

http://bigdatabigdave.info/archive/2013/03/08/scripting-create-table-statements-from-temp-table-definitions/

answered Nov 19, 2013 at 20:16

David

1,6111 gold badge11 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Zane Over a year ago

I'm not even sure that's what the OP is asking.

David Over a year ago

Just my best guess for what he's looking for. Not much to go on.

Collectives™ on Stack Overflow

Generate a column script

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related