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 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 providedwithout 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