Microsoft® SQL Server® 2012 Bible

829

Chapter 31: Managing Data in Windows Azure SQL Database

31

alter table tablename

drop column rowguid

FIGURE 31-20

Using bcp to import data into SQL Database.

The cool thing is that you don’t need to re-export the data. You can re-execute the bcp

import command.

Don’t forget to put the rowguid column back on the Users table. You can do this by using

the same syntax as before:

ALTER TABLE tablename

ADD rowguid uniqeidentifier

Summary

SQL Database is a big topic; this chapter was not intended to provide a deep examination of

SQL Database, but to provide a quick primer into subject, with a focus on data management

and the great benefi ts surrounding this great relational database hosted as a Platform as a

Service (PaaS) service.

This chapter began by providing an overview of what SQL Database is and why it exists,

as well as the great benefi ts that come with it, including high-availability and scalability,

c31.indd 829c31.indd 829 7/31/2012 10:00:31 AM7/31/2012 10:00:31 AM

http://www.it-ebooks.info