[PDF] [PDF] Transact-SQL Data Definition Language (DDL) - Microsoft

DROP Statements ALTER APPLICATION ROLE Changes the name, password, or default schema of an application role Transact-SQL Syntax Conventions



Previous PDF Next PDF





[PDF] SQL Server Naming Standards

SQL Server Standards Version 1 5 Shane Lively Michael Sarsany Page 1 of 24 I Naming Conventions The main goal of adopting a naming convention for 



T-SQL Keywords

These keywords define the grammar of T-SQL It's highly recommended that you avoid using these reserved keywords as identi- Nonreserved keywords in T- SQL include those that are part of the T-SQL grammar naming conventions, 6– 8



[PDF] SQL Server Naming Conventions and Standards - CMS

9 jan 2006 · SQL Server Naming Conventions and Standards 1 0 Databases, Files, and File Paths • The database name should accurately reflect the 



[PDF] MS SQL Server 2012 2014 Naming and Coding Standard

15 sept 2016 · Coding standards are conventions and methods developers follow when developing, editing or maintaining program code Better programming 



[PDF] SQL Server 2012 Transact-SQL DML Reference - Microsoft

Transact-SQL Syntax Conventions Syntax BULK INSERT [ database_name [ schema_name ] schema_name ] [ table_name view_name ] FROM 'data_file  



[PDF] Transact-SQL Data Definition Language (DDL) - Microsoft

DROP Statements ALTER APPLICATION ROLE Changes the name, password, or default schema of an application role Transact-SQL Syntax Conventions



[PDF] SQL SERVER NAMING CONVENTIONS AND STANDARDS

Tables are used to store data in the database The naming conventions for a table may have a "tbl" prefix, followed by the table name Moreover, TableName 



[PDF] Transact-SQL Reference - Documentation & Help

Transact-SQL Syntax Conventions The syntax diagrams in the Transact-SQL Reference use these conventions Convention Used for UPPERCASE

[PDF] t sql table naming conventions

[PDF] t sql variable naming conventions

[PDF] t state in 8085 microprocessor pdf

[PDF] t test excel (formula)

[PDF] t test graph in excel

[PDF] t test in excel

[PDF] t test in excel 2019

[PDF] t test in excel mac

[PDF] tabella ascii estesa esadecimale

[PDF] tabella ascii estesa italiano

[PDF] tabella caratteri ascii estesa

[PDF] tabella codice ascii estesa

[PDF] tabella codici ascii estesa

[PDF] tabella codici ascii estesa pdf

[PDF] tabelle ascii estesa

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

Copyright © 2012 by Microsoft Corporation

All rights reserved. No part of the contents of this book may be reproduced or transmitted in any form or by

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

CREATE PARTITION FUNCTION......................................................................................................... 492

CREATE PARTITION SCHEME ............................................................................................................. 497

CREATE PROCEDURE

............................................................................................................................. 501

CREATE QUEUE ........................................................................................................................................ 524

CREATE REMOTE SERVICE BINDING ............................................................................................... 531

CREATE RESOURCE POOL ................................................................................................................... 533

CREATE ROLE ............................................................................................................................................ 536

CREATE ROUTE ........................................................................................................................................ 538

CREATE RULE ............................................................................................................................................ 543

CREATE SCHEMA .................................................................................................................................... 546

CREATE SEARCH PROPERTY LIST ...................................................................................................... 550

CREATE SEQUENCE

................................................................................................................................ 553

CREATE SERVER AUDIT ......................................................................................................................... 559

CREATE SERVER AUDIT SPECIFICATION ........................................................................................ 565

CREATE SERVER ROLE ........................................................................................................................... 567

CREATE SERVICE ...................................................................................................................................... 568

CREATE SPATIAL INDEX ....................................................................................................................... 571

CREATE STATISTICS................................................................................................................................ 585

CREATE SYMMETRIC KEY ..................................................................................................................... 589

CREATE SYNONYM ................................................................................................................................ 594

CREATE TABLE .......................................................................................................................................... 598

IDENTITY (Property) ........................................................................................................................... 627

CREATE TRIGGER ..................................................................................................................................... 630

CREATE TYPE............................................................................................................................................. 645

CREATE USER ............................................................................................................................................ 651

CREATE VIEW ............................................................................................................................................ 659

CREATE WORKLOAD GROUP ............................................................................................................. 672

CREATE XML INDEX ............................................................................................................................... 675

CREATE XML SCHEMA COLLECTION ............................................................................................... 682

DISABLE TRIGGER ....................................................................................................................................... 689

DROP Statements ....................................................................................................................................... 692

DROP AGGREGATE ................................................................................................................................. 693

DROP APPLICATION ROLE .................................................................................................................. 693

DROP ASSEMBLY .................................................................................................................................... 695

DROP ASYMMETRIC KEY ..................................................................................................................... 696

DROP AVAILABILITY GROUP .............................................................................................................. 697

DROP BROKER PRIORITY ..................................................................................................................... 698

DROP CERTIFICATE ................................................................................................................................ 699

DROP CONTRACT ................................................................................................................................... 699

DROP CREDENTIAL ................................................................................................................................ 700

DROP CRYPTOGR

APHIC PROVIDER ................................................................................................ 701

DROP DATABASE .................................................................................................................................... 702

DROP DATABASE AUDIT SPECIFICATION ..................................................................................... 704

DROP DATABASE ENCRYPTION KEY ............................................................................................... 706

DROP DEFAULT ....................................................................................................................................... 707

DROP ENDPOINT .................................................................................................................................... 708

DROP EVENT NOTIFICATION ............................................................................................................. 709

DROP EVENT SESSION

.......................................................................................................................... 711

DROP FULLTEXT CATALOG ................................................................................................................. 711

DROP FULLTEXT INDEX ........................................................................................................................ 712

DROP FULLTEXT STOPLIST

.................................................................................................................. 713

DROP FUNCTION .................................................................................................................................... 714

DROP INDEX ............................................................................................................................................. 715

DROP LOGIN............................................................................................................................................. 725

DROP MASTER KEY ................................................................................................................................ 725

DROP MESSAGE TYPE ........................................................................................................................... 726

DROP PARTITION FUNCTION ............................................................................................................ 727

DROP PARTITION SCHEME ................................................................................................................. 728

DROP PROCEDURE................................................................................................................................. 729

DROP QUEUE............................................................................................................................................ 730

DROP REMOTE SERVICE BINDING ................................................................................................... 732

DROP RESOURCE POOL ....................................................................................................................... 732

DROP ROLE ............................................................................................................................................... 733

DROP ROUTE ............................................................................................................................................ 735

DROP RULE................................................................................................................................................ 735

DROP SCHEMA ........................................................................................................................................ 737

DROP SEARCH PROPERTY LIST ......................................................................................................... 738

DROP SEQUENCE .................................................................................................................................... 740

DROP SERVER AUDIT ............................................................................................................................ 741

DROP SERVER AUDIT SPECIFICATION ............................................................................................ 743

DROP SERVER ROLE............................................................................................................................... 744

DROP SERVICE ......................................................................................................................................... 746

DROP SIGNATURE .................................................................................................................................. 746

DROP STATISTICS ................................................................................................................................... 748

DROP SYMMETRIC KEY ........................................................................................................................ 749

DROP SYNONYM .................................................................................................................................... 750

DROP TABLE ............................................................................................................................................. 751

DROP TRIGGER ........................................................................................................................................ 754

DROP TYPE ................................................................................................................................................ 756

DROP USER ............................................................................................................................................... 757

DROP VIEW ............................................................................................................................................... 758

DROP WORKLOAD GROUP ................................................................................................................. 760

DROP XML SCHEMA COLLECTION .................................................................................................. 761

ENABLE TRIGGER ........................................................................................................................................ 763

UPDATE STATISTICS .................................................................................................................................. 765

TRUNCATE TABLE ....................................................................................................................................... 769

7

Data Definition Language (DDL) Statements

(Transact-SQL) 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.

In this Section

ALTER Statements (Transact-SQL)

CREATE Statements (Transact-SQL)

DISABLE TRIGGER (Transact-SQL)

DISABLE TRIGGER (Transact-SQL)

DROP Statements (Transact-SQL)

ENABLE TRIGGER (Transact-SQL)

TRUNCATE TABLE (Transact-SQL)

UPDATE STATISTICS (Transact-SQL)

ALTER Statements

SQL Server Transact-SQL contains the following ALTER statements. Use ALTER statements to modify the definition of existing entities. For example, use ALTER TABLE to add a new column to a table, or use ALTER DATABASE to set database options.

In this Section

ALTER APPLICATION ROLE ALTER EVENT SESSION ALTER ROLE

ALTER ASSEMBLY ALTER FULLTEXT CATALOG ALTER ROUTE

ALTER ASYMMETRIC KEY ALTER FULLTEXT INDEX ALTER SCHEMA ALTER AUTHORIZATION ALTER FULLTEXT STOPLIST ALTER SEARCH PROPERTY LIST (Transact-SQL) ALTER BROKER PRIORITY ALTER FUNCTION ALTER SEQUENCE (Transact- SQL)

ALTER CERTIFICATE ALTER INDEX ALTER SERVER AUDIT

8

ALTER CREDENTIAL ALTER LOGIN ALTER SERVER AUDIT

quotesdbs_dbs17.pdfusesText_23