Has anybody ever tried to do this. I can't figure it out. All I want to do is take an existing table that already has values in the column that I want to change and add the identity property to yes and set the identity seed and increment to a specific number. I know you can do it in the CREATE TABLE statement but is there a way to use the ALTER TABLE command?Create a new table with same schema and the Identity column, then load the data into the new table, and then drop the old table.|||i don't think so. even when you trying to remove the identity from a table, it will drop and recreate the table in the backgound. it can't just
modify the table structure.
Originally posted by randyfoy
Has anybody ever tried to do this. I can't figure it out. All I want to do is take an existing table that already has values in the column that I want to change and add the identity property to yes and set the identity seed and increment to a specific number. I know you can do it in the CREATE TABLE statement but is there a way to use the ALTER TABLE command?|||even though I can just go to the design view of the table through the Enterprise Manager and change the property? It works fine if I do it manually.|||and try to run profiler while you're doing it, guess you'd answer your own question
Showing posts with label property. Show all posts
Showing posts with label property. Show all posts
Monday, March 12, 2012
Sunday, February 19, 2012
how to access table column description?
How can I programatically access column descriotion property? Thanks.
RobertRead about "extended properties" in Books Online.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Robert Mitosinka" <robert_mitosinka@.hotmail.com> wrote in message
news:uywpNSx8EHA.1188@.tk2msftngp13.phx.gbl...
> How can I programatically access column descriotion property? Thanks.
> Robert
>
RobertRead about "extended properties" in Books Online.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Robert Mitosinka" <robert_mitosinka@.hotmail.com> wrote in message
news:uywpNSx8EHA.1188@.tk2msftngp13.phx.gbl...
> How can I programatically access column descriotion property? Thanks.
> Robert
>
Labels:
access,
column,
database,
descriotion,
description,
microsoft,
mysql,
oracle,
programatically,
property,
server,
sql,
table
how to access table column description?
How can I programatically access column descriotion property? Thanks.
Robert
Read about "extended properties" in Books Online.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Robert Mitosinka" <robert_mitosinka@.hotmail.com> wrote in message
news:uywpNSx8EHA.1188@.tk2msftngp13.phx.gbl...
> How can I programatically access column descriotion property? Thanks.
> Robert
>
Robert
Read about "extended properties" in Books Online.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Robert Mitosinka" <robert_mitosinka@.hotmail.com> wrote in message
news:uywpNSx8EHA.1188@.tk2msftngp13.phx.gbl...
> How can I programatically access column descriotion property? Thanks.
> Robert
>
Labels:
access,
column,
database,
descriotion,
description,
microsoft,
mysql,
oracle,
programatically,
property,
server,
sql,
table
how to access table column description?
How can I programatically access column descriotion property? Thanks.
RobertRead about "extended properties" in Books Online.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Robert Mitosinka" <robert_mitosinka@.hotmail.com> wrote in message
news:uywpNSx8EHA.1188@.tk2msftngp13.phx.gbl...
> How can I programatically access column descriotion property? Thanks.
> Robert
>
RobertRead about "extended properties" in Books Online.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Robert Mitosinka" <robert_mitosinka@.hotmail.com> wrote in message
news:uywpNSx8EHA.1188@.tk2msftngp13.phx.gbl...
> How can I programatically access column descriotion property? Thanks.
> Robert
>
Labels:
access,
column,
database,
descriotion,
description,
microsoft,
mysql,
oracle,
programatically,
property,
server,
sql,
table
Subscribe to:
Posts (Atom)