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.
| Author |
Topic |
|
shekhar_dba
Starting Member
39 Posts |
 Posted - 2007-04-02 : 15:32:27
|
| Hi guru !!I want to create a table that can created dynamicly based on front end application.table should handle insertion and edit also. please help me to get out of this situation.thanksshekhar |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-02 : 15:43:21
|
| A guru would tell you that you should not do this. You will almost certainly end up with a poorly designed database, which you probably already have if you think you need this.Please explain in detail why you need this functionality.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
ElManiak
Starting Member
4 Posts |
Posted - 2007-04-02 : 16:42:32
|
quote:
Originally posted by shekhar_dba
Hi guru !!I want to create a table that can created dynamicly based on front end application.table should handle insertion and edit also. please help me to get out of this situation.thanksshekhar
for this you need stored procedures that creats tables, and you need to give rights to the users to exectute th SP and also to create tables. SO you are openeing a security door, and the perfect way to have an uncontroled database design.Never do that unless God asked you for it. |
|
|
|
|
|
|
dynamic create table