How to create and delete tables in SQL Server.

[darsh999]

I have started learning SQL server...please help me to tell me how to create and delete table in a database!!

[Atli]

Hi, and welcome to TSDN!

Take a look at this article. Even tho it's written for MySQL the query examples should work on SQL Server as well.

In the future, you might want to consider posting questions about SQL Server in the SQL Server forums, accessible from blue navigation bar at the top of the page.

[Atli]

I have edited the thread's title to better describe it's content and moved it to the SQL Server forums.
Please read the posting guidelines before posting.

Moderator

[bwestover]

Here is the Microsoft SQL language reference.

Also a very good book I recommend is called SQL Bible by Alex Siegel and Boris Trukhnov. ISBN # 0764525840

You can get it here if your interested.
Barnes & Noble

[Purple]

Hi darsh999 ,

If you have enterprise manager (sql 2000) or SQL server studio (sql 2005) availabile you can create and delete databases and tables through a gui allowing you to visualise the referential links between the tables.

If not, a good place to start if you are learning is to download SQL 2005 Express and do a full install. This will give you the SQL server studio to practise with.

Regards Purple