How can I create table in SQL Server 2000 at runtime using C#??????

I want to create table in SQL Server 2000 as the page load using C# with proper attributes defined in the table while creating table.


Please suggest me if any one knows the answer.

How can I create table in SQL Server 2000 at runtime using C#??????
Look at the System.Data.SqlClient namespace.





SqlConnection connection = new SqlConnection(connectionString)


SqlCommand command = new SqlCommand()


command.CommandText = "CREATE TABLE foo (Col1 int not null)


command.Connection = connection;


command.ExecuteNonQuery()





There are also the ADO.NET calls if you don't like writing all the SQL queries. VS 2005 also comes with the Microsoft.SqlServer.Management.Smo assemblies and namespace which can do this too.