Whether and How to do it with a simple alter table alter column statement?
Thanks,
-charles
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
by Charles Y » Thu, 08 Nov 2001 12:11:35
Whether and How to do it with a simple alter table alter column statement?
Thanks,
-charles
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
by Tibor Karasz » Thu, 08 Nov 2001 17:00:33
You can't. You have to re-create the table or add/drop columns. This is what EM does.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sql...
> Whether and How to do it with a simple alter table alter column statement?
> Thanks,
> -charles
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
by Dejan Sark » Thu, 08 Nov 2001 17:09:52
unfortunately there is no simple way. You'll nave to create a new table andQuote:> Whether and How to do it with a simple alter table alter column statement?
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
by BP Margoli » Fri, 09 Nov 2001 09:15:47
http://www.tsqlsolutions.com/Articles/Index.cfm?ArticleID=22080
-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.
Quote:> Whether and How to do it with a simple alter table alter column statement?
> Thanks,
> -charles
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
1. How to change an identity column to non identity column
I like to know how to use script to change an identity column to non
identity column.
Thank you very much.
--
Lijun
=======================================================
Lijun Yang
=======================================================
2. 9i Application Server httpd
3. Identity column reverts to non-identity
4. data binding problem in Sub command
5. changing an identity column to non identity
6. Assign Users to a new Login Name
7. How do make an identity column NOT an identity column
9. ALTER TABLE ... ALTER COLUMN IDENTITY
10. Identity Column lost its identity
11. Changing Identity column to Identity not for replication?
12. Setting the Next identity value on an IDENTITY column
13. Identity columns and invalid identity values.