create table for every user

Question

I want create tables for every user.there are so many customers.how can i do it?

Abhay Shanker · Answer

Why do you want table for every user.It's wrong. Can you please explain your requirement why you need to create customer specific table.

Ramchand Repalle · Answer

Hello Chathurika, As my personal view, create a table for every customer is not a good idea, even though i don't know about your full requirement. So, you can achieve in one of the way at SQL server level is: 1. First insert all the customers in one table 2. create a stored procedure like the below CREATE PROCEDURE CustomerTableCreation( @Name NVARCHAR(100) ) AS BEGIN DECLARE @SQL NVARCHAR(1000) SET @SQL = 'CREATE TABLE ' + @Name + '(Id INT)' EXEC(@SQL) END 3. create one cursor it gets the customer names and create a table for all customer names DECLARE @name VARCHAR(100) DECLARE db_cursor CURSOR FOR SELECT distinct Name FROM Customer OPEN db_cursor FETCH NEXT FROM db_cursor INTO @name WHILE @@FETCH_STATUS = 0 BEGIN EXEC CustomerTableCreation @name FETCH NEXT FROM db_cursor INTO @name END CLOSE db_cursor DEALLOCATE db_cursor Note: The customer name/id should satisfy the table name conditions in sql server (Table Name Format, Unique Table Name etc) If you want to achieve through code level, you can call the stored procedure (mentioned in 2nd point) from code level. it would creates a table for you.. Thanks, Ramchand.

Joginder Banger · Answer

This is the wrong way if you create the table for every user. suppose have in your data around one thousand records then what you create one thousand table. just create a single table for user records. if you want add more information like account related , address , job company and so on. create different table and join with every one. it's a simple and fast performance.

Munesh Sharma · Answer

1ST CREATE connection SqlConnection cn=new SqlConnection( @" server=MUNESH\SQLEXPRESS;database=master;integrated security=SSPI" ); cn.Open(); //here you create your table SqlCommand cmd=new SqlCommand( " create table '" +user1+ ,cn); cmd.ExecuteNonQuery(); cn.Close(); MessageBox.Show( " Continue" );