Re: add a new table to the database or add a new column to an existing table.

•

•

•

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 423,766 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,419 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS SQL advertiser: Programming Forums

add a new table to the database or add a new column to an existing table.

•

•

Join Date: Dec 2004

Location: London or Slovakia

Posts: 2,434

Reputation: peter_budo is a jewel in the rough

peter_budo is a jewel in the rough

peter_budo is a jewel in the rough

peter_budo is a jewel in the rough

peter_budo is a jewel in the rough

Rep Power: 11

Solved Threads: 295

peter_budo peter_budo is offline

peter_budo is offline

Offline

Code tags enforcer

Re: add a new table to the database or add a new column to an existing table.

#2

Apr 7th, 2008

Create table

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
CREATE TABLE table_name
(
column_name1 data_type,
column_name2 data_type,
)
CREATE TABLE table_name
(
column_name1 data_type,
column_name2 data_type,
)

The problem that you facing here is

Table is always same so you just run your prepared statement
Tables can be different, you must provide a way/interface through which user can declare table name, column types, you just add the magic words CREATE TABLE and then execute it

Add column

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
ALTER TABLE table_name 
ADD column_name datatype
ALTER TABLE table_name 
ADD column_name datatype

Remove column

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
ALTER TABLE table_name 
DROP COLUMN column_name
ALTER TABLE table_name 
DROP COLUMN column_name

Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.

Reply With Quote

Forum Highlights

Related Features

DANIWEB FEATURE INDEX

Advertisement

Statistics

Members: 423,766

Users Online Now: 3,419

Active IRC Users: 25

Forum Threads: 135,701

Forum Posts: 689,829

Code Snippets: 903

Blogs: 150

Blog Entries: 2,286

Directory Links: 569