Transact-SQL Data Definition Language - DDL- Reference.pdf - books 1 - wiklef8

Transact-SQL Data Definition

Language (DDL) Reference

SQL Server 2012 Books Online

Summary : Data Definition Language (DDL) is a vocabulary used to define data

structures in SQL Server 2012. Use these statements to create, alter, or drop data

structures in an instance of SQL Server.

Category: Reference

Applies to : SQL Server 2012

Source : SQL Server Books Online ( link to source content )

E-book publication date : June 2012

any means without the written permission of the publisher.

Microsoft and the trademarks listed at

http://www.microsoft.com/about/legal/en/us/IntellectualProperty/Trademarks/EN-US.aspx are trademarks of

the Microsoft group of companies. All other marks are property of their respective owners.

The example companies, organizations, products, domain names, email addresses, logos, people, places, and

events depicted herein are fictitious. No association with any real company, organization, product, domain

name, email address, logo, person, place, or event is intended or should be inferred.

This book expresses the author’s views and opinions. The information contained in this book is provided

without any express, statutory, or implied warranties. Neither the authors, Microsoft Corporation, nor its

resellers, or distributors will be held liable for any damages caused or alleged to be caused either directly or

indirectly by this book.

Contents

Data Definition Language (DDL) Statements (Transact-SQL) ......................................................... 7

ALTER Statements............................................................................................................................................ 7

ALTER APPLICATION ROLE....................................................................................................................... 8

ALTER ASSEMBLY.......................................................................................................................................11

ALTER ASYMMETRIC KEY........................................................................................................................15

ALTER AUTHORIZATION .........................................................................................................................18

ALTER AVAILABILITY GROUP.................................................................................................................22

ALTER BROKER PRIORITY........................................................................................................................37

ALTER CERTIFICATE...................................................................................................................................40

ALTER CREDENTIAL...................................................................................................................................43

ALTER CRYPTOGRAPHIC PROVIDER...................................................................................................44

ALTER DATABASE ......................................................................................................................................46

ALTER DATABASE File and Filegroup Options............................................................................51

ALTER DATABASE SET Options.........................................................................................................64

ALTER DATABASE Database Mirroring ..........................................................................................96

ALTER DATABASE SET HADR.......................................................................................................... 102

ALTER DATABASE Compatibility Level........................................................................................ 105

ALTER DATABASE AUDIT SPECIFICATION..................................................................................... 116

ALTER DATABASE ENCRYPTION KEY............................................................................................... 119

ALTER ENDPOINT ................................................................................................................................... 120

ALTER EVENT SESSION ......................................................................................................................... 123

ALTER FULLTEXT CATALOG................................................................................................................. 133

ALTER FULLTEXT INDEX........................................................................................................................ 135

ALTER FULLTEXT STOPLIST ................................................................................................................. 144

ALTER FUNCTION ................................................................................................................................... 146

ALTER INDEX ............................................................................................................................................ 157

ALTER LOGIN............................................................................................................................................ 174

ALTER MASTER KEY................................................................................................................................ 178

ALTER MESSAGE TYPE........................................................................................................................... 180

ALTER PARTITION FUNCTION............................................................................................................ 182

ALTER PARTITION SCHEME ................................................................................................................ 185

ALTER PROCEDURE................................................................................................................................ 187

ALTER QUEUE........................................................................................................................................... 193

ALTER REMOTE SERVICE BINDING .................................................................................................. 197

ALTER RESOURCE GOVERNOR.......................................................................................................... 198

ALTER RESOURCE POOL ...................................................................................................................... 203

ALTER ROLE............................................................................................................................................... 206

ALTER ROUTE ........................................................................................................................................... 207

ALTER SCHEMA ....................................................................................................................................... 211

ALTER SEARCH PROPERTY LIST......................................................................................................... 214

ALTER SEQUENCE ................................................................................................................................... 219

ALTER SERVER AUDIT............................................................................................................................ 223

ALTER SERVER AUDIT SPECIFICATION ........................................................................................... 229

ALTER SERVER CONFIGURATION..................................................................................................... 231

ALTER SERVER ROLE.............................................................................................................................. 236

ALTER SERVICE......................................................................................................................................... 239

ALTER SERVICE MASTER KEY.............................................................................................................. 241

ALTER SYMMETRIC KEY........................................................................................................................ 244

ALTER TABLE............................................................................................................................................. 246

column_definition ............................................................................................................................... 273

column_constraint .............................................................................................................................. 277

computed_column_definition ........................................................................................................ 283

table_constraint ................................................................................................................................... 287

index_option ......................................................................................................................................... 292

ALTER TRIGGER........................................................................................................................................ 297

ALTER USER............................................................................................................................................... 303

ALTER VIEW............................................................................................................................................... 307

ALTER WORKLOAD GROUP ................................................................................................................ 310

ALTER XML SCHEMA COLLECTION.................................................................................................. 315

CREATE Statements.................................................................................................................................... 322

CREATE AGGREGATE ............................................................................................................................. 323

CREATE APPLICATION ROLE............................................................................................................... 325

CREATE ASSEMBLY................................................................................................................................. 327

CREATE ASYMMETRIC KEY.................................................................................................................. 331

CREATE AVAILABILITY GROUP........................................................................................................... 335

CREATE BROKER PRIORITY.................................................................................................................. 354

CREATE CERTIFICATE............................................................................................................................. 361

CREATE COLUMNSTORE INDEX........................................................................................................ 366

CREATE CONTRACT ............................................................................................................................... 371

CREATE CREDENTIAL............................................................................................................................. 374

CREATE CRYPTOGRAPHIC PROVIDER............................................................................................. 376

CREATE DATABASE ................................................................................................................................ 378

CREATE DATABASE AUDIT SPECIFICATION.................................................................................. 400

CREATE DATABASE ENCRYPTION KEY............................................................................................ 403

CREATE DEFAULT.................................................................................................................................... 405

CREATE ENDPOINT ................................................................................................................................ 407

CREATE EVENT NOTIFICATION ......................................................................................................... 414

CREATE EVENT SESSION ...................................................................................................................... 418

CREATE FULLTEXT CATALOG.............................................................................................................. 425

CREATE FULLTEXT INDEX..................................................................................................................... 427

CREATE FULLTEXT STOPLIST .............................................................................................................. 434

CREATE FUNCTION ................................................................................................................................ 436

CREATE INDEX ......................................................................................................................................... 457

CREATE LOGIN......................................................................................................................................... 482

CREATE MASTER KEY............................................................................................................................. 488

CREATE MESSAGE TYPE........................................................................................................................ 489

Transact-SQL Data Definition Language - DDL- Reference.pdf

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: