alter table column - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

alter table column

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-11-15 : 10:01:43

James writes "I have a SQL server 2000 database on a server that I cannot see via Enterprise Manager, but can obviously access via the net.

I need to change 2 tables in the database.

1. WebLinkCodes
2. EmailLinkCodes

Both of these tables have Primary Keys, but the Identity is set to No.

I need to change these to YES.

Table: WebLinkCodes
Column to Change: WebLinkCodeID

Table: EmailLinkCodes
Column to Change: EmailLinkCodeID

I also need to keep the existing numbers found in the Primary Key columns.

Can you help.

Thanks

James Campbell"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources