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 Development (2000)
 creating database tables on fly

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-06-11 : 09:53:57
rahil writes "Can i create database tables on fly.I have a list box depending on the number of entries selected in the list box i must eb able to create that many tables with those names
thanks"

mr_mist
Grunnio

1870 Posts

Posted - 2003-06-11 : 10:01:46
You could do it with dynamic SQL.

I would try to avoid it though, you are entering into a world of pain if you go in that direction.

-------
Moo.
Go to Top of Page

cas_o
Posting Yak Master

154 Posts

Posted - 2003-06-12 : 04:19:29
Search Books On Line for CREATE TABLE syntax

;-]
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2003-06-12 : 09:02:05
I think you have a MAJOR design issue.

With better design you could probably avoid this, which sounds like a NASTY solution. Why don't you tell us why you need to do this and maybe we can help you out.

Damian
Go to Top of Page
   

- Advertisement -