Re: Alter Table Property

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
Date: Thu, 13 Sep 2007 22:17:06 +0000 (UTC)

Ryan (Ryan@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:

I have a sql server 2005 based MyDB.mdf and MyDB.log in c:\MyData
folder. All client components are installed on my machine but do not
have Management Studio. How do I ALTER a table property in this database
either by using osql or sqlcmd command line tools or any other tools?

You run the same ALTER statement as you would have run in Mgmt Studio.

sqlcmd -d MyDB

and off you go. (Provided that MyDB is also the database name, and not
only the filename.)

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Prev by Date: ANN: MS SQL Field Box 1.7
Next by Date: Re: SSMS Pain in the butt
Previous by thread: ANN: MS SQL Field Box 1.7
Next by thread: can someone have idea on this perfmon result
Index(es):
- Date
- Thread

Relevant Pages

Re: SQL Express - Identity specification property - how to change
... UPDATE tbl ... You can use ALTER TABLE ALTER COLUMN to add an IDENTITY column, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(comp.databases.ms-sqlserver)
Re: Appending tables
... FROM tbl3 WHERE a.PART_NUM = b.PART_NUM) ... You cannot alter the field to make it a PK, but you can alter the table ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(comp.databases.ms-sqlserver)
Re: BCP import error - Cannot insert duplicate key row in object
... ALTER TABLE tbl ALTER COLUMN col varchar ... o Instead of Latin1_General you may want to use the collation specifier ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(microsoft.public.sqlserver.server)
Re: Datatype-convertion in TSQL
... overflow error converting expression to data type datetime' ... I would guess that ALTER TABLE ALTER COLUMN ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(comp.databases.ms-sqlserver)
Re: Assisted Editor
... management Studio. ... the end of the parameter lsit. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(microsoft.public.sqlserver.tools)