Solved

Create a database script?

Posted on 2007-12-04
3
226 Views
Last Modified: 2010-03-19

Create a an alter command to add a field to a table in sql 2005.
0
Comment
Question by:mathieu_cupryk
3 Comments
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 250 total points
ID: 20403630
ALTER TABLE <TableName>
ADD newField Varchar(100)
0
 
LVL 3

Expert Comment

by:cforant
ID: 20403636
ALTER TABLE table_name ADD column_name column-definition;

For example:
ALTER TABLE supplier ADD supplier_name  varchar2(50);

0
 

Author Comment

by:mathieu_cupryk
ID: 20403712
First come first serve. Thanks guys.
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sql query help 7 96
How to replace WHITESPACE (1 or more spaces) in a field with a SINGLE DASH? 4 30
Need help with a query 3 44
Passing value to a stored procedure 8 90
If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now