Views are based on the result-set of an SQL query. CREATE VIEW constructs a virtual table that has no physical data therefore other operations like ALTER VIEW and DROP VIEW only change metadata.

Provides a basic SQL DDL statement for a Table/View. Created this SPROC after realizing that SQL Server does not provide a way to programatically create DDL for tables / views.

The move from Microsoft SQL Server 2000 to 2005 was a big leap with many new functionalities and features introduced. The concept of DDL Triggers was one such new feature.

Multi-tenancy is one of the most important features in Software as a Service(SaaS). In order to reduce cost, SaaS service vendors typically implement multi-tenant enabled database on top of ...

This research developed the MySQL Sandbox, a secured environment for processing SQL queries. It was implemented as a RESTful web service having three services - sandbox database creation, SQL ...