Printing all tables in a database with Microsoft.SqlServer.Management.Smo

gistfile1.cs

// From microsoft.sqlserver.smo.dll
using Microsoft.SqlServer.Management.Smo;

void PrintTables()
{
	Server server = new Server("(local)");
	server.ConnectionContext.ConnectAsUserName = "sa";
	server.ConnectionContext.ConnectAsUserPassword = "Passw0rd";
	Database db = server.Databases["mydatabase"];
	foreach (Table table in db.Tables)
	{
		Console.WriteLine(string.Format("[{0}]", table.Name));
		foreach (Column column in table.Columns)
		{
			Console.WriteLine(string.Format("\t{0} {1} {2} {3}",
			column.Name,
			column.DataType.Name,
			column.Default,
			column.DataType.MaximumLength));
		}
		Console.WriteLine("");
	}
	Console.Read();
}
  }