Skip to content

Commit 0beae04

Browse files
TrishaMcTrishaMc
authored
Merge pull request #6802 from CarlRabeler/restorefilelist
[sql] tabbed monikers
2 parents 9d31a40 + 089d8da commit 0beae04

7 files changed

Lines changed: 512 additions & 73 deletions

‎docs/t-sql/statements/alter-database-transact-sql-file-and-filegroup-options.md‎

Lines changed: 43 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -45,17 +45,35 @@ caps.latest.revision: 61
4545
author: CarlRabeler
4646
ms.author: carlrab
4747
manager: craigg
48-
monikerRange: "=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017"
48+
monikerRange: "=azuresqldb-mi-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017"
4949
---
5050
# ALTER DATABASE (Transact-SQL) File and Filegroup Options
5151

5252
Modifies the files and filegroups associated with the database. Adds or removes files and filegroups from a database, and changes the attributes of a database or its files and filegroups. For other ALTER DATABASE options, see [ALTER DATABASE](../../t-sql/statements/alter-database-transact-sql.md).
5353

54-
Click one of the following tabs for the syntax, arguments, remarks, permissions, and examples for a particular SQL version with which you are working.
55-
5654
For more information about the syntax conventions, see [Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md).
5755

58-
# [SQL Server](#tab/sqlserver)
56+
## Click a product!
57+
58+
In the following row, click whichever product name you are interested in. The click displays different content here on this webpage, appropriate for whichever product you click.
59+
60+
::: moniker range=">=sql-server-2016||>=sql-server-linux-2017||=sqlallproducts-allversions"
61+
62+
> [!div class="mx-tdCol2BreakAll"]
63+
> <table>
64+
> <tr>
65+
> <th> &nbsp; </th>
66+
> <th> &nbsp; </th>
67+
> </tr>
68+
> <tr>
69+
> <th><strong><em>* SQL Server *<br />&nbsp;</em></strong></th>
70+
> <th><a href="alter-database-transact-sql-file-and-filegroup-options.md?view=azuresqldb-mi-current">SQL Database<br />Managed Instance</a></th>
71+
> </tr>
72+
> </table>
73+
74+
&nbsp;
75+
76+
# SQL Server
5977

6078
## Syntax
6179

@@ -653,7 +671,24 @@ GO
653671
[sp_filestream_force_garbage_collection](../../relational-databases/system-stored-procedures/filestream-and-filetable-sp-filestream-force-garbage-collection.md)
654672
[Database File Initialization](../../relational-databases/databases/database-instant-file-initialization.md)
655673

656-
# [SQL DB Managed Instance](#tab/sqldbmi)
674+
::: moniker-end
675+
::: moniker range="=azuresqldb-mi-current||=sqlallproducts-allversions"
676+
677+
> [!div class="mx-tdCol2BreakAll"]
678+
> <table>
679+
> <tr>
680+
> <th> &nbsp; </th>
681+
> <th> &nbsp; </th>
682+
> </tr>
683+
> <tr>
684+
> <th><a href="alter-database-transact-sql-file-and-filegroup-options.md?view=sql-server-2016">SQL Server</a></th>
685+
> <th><strong><em>* SQL Database<br />Managed Instance *</em></strong></th>
686+
> </tr>
687+
> </table>
688+
689+
&nbsp;
690+
691+
# Azure SQL Database Managed Instance
657692

658693
Use this statement with a database in Azure SQL Database Managed Instance.
659694

@@ -1032,4 +1067,6 @@ GO
10321067
[sys.data_spaces](../../relational-databases/system-catalog-views/sys-data-spaces-transact-sql.md)
10331068
[sys.filegroups](../../relational-databases/system-catalog-views/sys-filegroups-transact-sql.md)
10341069
[sys.master_files](../../relational-databases/system-catalog-views/sys-master-files-transact-sql.md)
1035-
[DBCC SHRINKFIL](../../t-sql/database-console-commands/dbcc-shrinkfile-transact-sql.md)
1070+
[DBCC SHRINKFIL](../../t-sql/database-console-commands/dbcc-shrinkfile-transact-sql.md)
1071+
1072+
::: moniker-end

‎docs/t-sql/statements/alter-database-transact-sql-set-options.md‎

Lines changed: 78 additions & 17 deletions
Large diffs are not rendered by default.

‎docs/t-sql/statements/alter-database-transact-sql.md‎

Lines changed: 13 additions & 13 deletions
Original file line numberDiff line numberDiff line change
@@ -30,7 +30,7 @@ ms.author: carlrab
3030
manager: craigg
3131
monikerRange: ">=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-current||=azuresqldb-mi-current||=azure-sqldw-latest||>=aps-pdw-2016||=sqlallproducts-allversions"
3232
---
33-
# ALTER DATABASE (Transact-SQL)
33+
# ALTER DATABASE (Transact-SQL)
3434

3535
Modifies certain configuration options of a database.
3636

@@ -54,9 +54,9 @@ In the following row, click whichever product name you are interested in. The cl
5454
> <th> &nbsp; </th>
5555
> </tr>
5656
> <tr>
57-
> <th><strong><em>* SQL Server *</em></strong></th>
58-
> <th><a href="alter-database-transact-sql.md?view=azuresqldb-current">SQL DB<br />logical server</a></th>
59-
> <th><a href="alter-database-transact-sql.md?view=azuresqldb-mi-current">SQL DB<br />Managed Instance</a></th>
57+
> <th><strong><em>* SQL Server *<br />&nbsp;</em></strong></th>
58+
> <th><a href="alter-database-transact-sql.md?view=azuresqldb-current">SQL Database<br />logical server</a></th>
59+
> <th><a href="alter-database-transact-sql.md?view=azuresqldb-mi-current">SQL Database<br />Managed Instance</a></th>
6060
> <th><a href="alter-database-transact-sql.md?view=azure-sqldw-latest">SQL Data<br />Warehouse</a></th>
6161
> <th><a href="alter-database-transact-sql.md?view=aps-pdw-2016">SQL Parallel<br />Data Warehouse</a></th>
6262
> </tr>
@@ -294,8 +294,8 @@ GO
294294
> </tr>
295295
> <tr>
296296
> <th><a href="alter-database-transact-sql.md?view=sql-server-2016">SQL Server</a></th>
297-
> <th style="border: 1"><strong><em>* SQL DB<br />logical server *</em></strong></th>
298-
> <th><a href="alter-database-transact-sql.md?view=azuresqldb-mi-current">SQL DB<br />Managed Instance</a></th>
297+
> <th><strong><em>* SQL Database<br />logical server *</em></strong></th>
298+
> <th><a href="alter-database-transact-sql.md?view=azuresqldb-mi-current">SQL Database<br />Managed Instance</a></th>
299299
> <th><a href="alter-database-transact-sql.md?view=azure-sqldw-latest">SQL Data<br />Warehouse</a></th>
300300
> <th><a href="alter-database-transact-sql.md?view=aps-pdw-2016">SQL Parallel<br />Data Warehouse</a></th>
301301
> </tr>
@@ -658,8 +658,8 @@ ALTER DATABASE db1 FAILOVER
658658
> </tr>
659659
> <tr>
660660
> <th><a href="alter-database-transact-sql.md?view=sql-server-2016">SQL Server</a></th>
661-
> <th><a href="alter-database-transact-sql.md?view=azuresqldb-current">SQL DB<br />logical server</a></th>
662-
> <th><strong><em>* SQL DB<br />Managed Instance</th>
661+
> <th><a href="alter-database-transact-sql.md?view=azuresqldb-current">SQL Database<br />logical server</a></th>
662+
> <th><strong><em>* SQL Database<br />Managed Instance *</em></strong></th>
663663
> <th><a href="alter-database-transact-sql.md?view=azure-sqldw-latest">SQL Data<br />Warehouse</a></th>
664664
> <th><a href="alter-database-transact-sql.md?view=aps-pdw-2016">SQL Parallel<br />Data Warehouse</a></th>
665665
> </tr>
@@ -797,8 +797,8 @@ ALTER DATABASE WideWorldImporters
797797
> </tr>
798798
> <tr>
799799
> <th><a href="alter-database-transact-sql.md?view=sql-server-2016">SQL Server</a></th>
800-
> <th><a href="alter-database-transact-sql.md?view=azuresqldb-current">SQL DB<br />logical server</a></th>
801-
> <th><a href="alter-database-transact-sql.md?view=azuresqldb-mi-current">SQL DB<br />Managed Instance</a></th>
800+
> <th><a href="alter-database-transact-sql.md?view=azuresqldb-current">SQL Database<br />logical server</a></th>
801+
> <th><a href="alter-database-transact-sql.md?view=azuresqldb-mi-current">SQL Database<br />Managed Instance</a></th>
802802
> <th><strong><em>* SQL Data<br />Warehouse *</em></strong></th>
803803
> <th><a href="alter-database-transact-sql.md?view=aps-pdw-2016">SQL Parallel<br />Data Warehouse</a></th>
804804
> </tr>
@@ -910,7 +910,7 @@ ALTER DATABASE dw1 MODIFY ( MAXSIZE=10240 GB, SERVICE_OBJECTIVE= 'DW1200' );
910910

911911
## See Also
912912
[CREATE DATABASE (Azure SQL Data Warehouse)](../../t-sql/statements/create-database-transact-sql.md?&tabs=sqldw.md)
913-
[SQL Data Warehouse list of reference articles](https://azure.microsoft.com/en-us/documentation/articles/sql-data-warehouse-overview-reference/)
913+
[SQL Data Warehouse list of reference articles](https://azure.microsoft.com/documentation/articles/sql-data-warehouse-overview-reference/)
914914

915915
::: moniker-end
916916
::: moniker range="=aps-pdw-2016||=sqlallproducts-allversions"
@@ -926,8 +926,8 @@ ALTER DATABASE dw1 MODIFY ( MAXSIZE=10240 GB, SERVICE_OBJECTIVE= 'DW1200' );
926926
> </tr>
927927
> <tr>
928928
> <th><a href="alter-database-transact-sql.md?view=sql-server-2016">SQL Server</a></th>
929-
> <th><a href="alter-database-transact-sql.md?view=azuresqldb-current">SQL DB<br />logical server</a></th>
930-
> <th><a href="alter-database-transact-sql.md?view=azuresqldb-mi-current">SQL DB<br />Managed Instance</a></th>
929+
> <th><a href="alter-database-transact-sql.md?view=azuresqldb-current">SQL Database<br />logical server</a></th>
930+
> <th><a href="alter-database-transact-sql.md?view=azuresqldb-mi-current">SQL Database<br />Managed Instance</a></th>
931931
> <th><a href="alter-database-transact-sql.md?view=azure-sqldw-latest">SQL Data<br />Warehouse</a></th>
932932
> <th><strong><em>* SQL Parallel<br />Data Warehouse *</em></strong></th>
933933
> </tr>

‎docs/t-sql/statements/backup-transact-sql.md‎

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -73,8 +73,8 @@ In the following row, click whichever product name you are interested in. The cl
7373
> <th> &nbsp; </th>
7474
> </tr>
7575
> <tr>
76-
> <th><strong><em>* SQL Server *</em></strong></th>
77-
> <th><a href="backup-transact-sql.md?view=azuresqldb-mi-current">SQL DB<br />Managed Instance</a></th>
76+
> <th><strong><em>* SQL Server *<br />&nbsp;</em></strong></th>
77+
> <th><a href="backup-transact-sql.md?view=azuresqldb-mi-current">SQL Database<br />Managed Instance</a></th>
7878
> <th><a href="backup-transact-sql.md?view=aps-pdw-2016">SQL Parallel<br />Data Warehouse</a></th>
7979
> </tr>
8080
> </table>
@@ -960,7 +960,7 @@ WITH STATS = 5;
960960
> </tr>
961961
> <tr>
962962
> <th><a href="backup-transact-sql.md?view=sql-server-2016">SQL Server</a></th>
963-
> <th><strong><em>* SQL DB<br />Managed Instance</th>
963+
> <th><strong><em>* SQL Database<br />Managed Instance *</em></strong></th>
964964
> <th><a href="backup-transact-sql.md?view=aps-pdw-2016">SQL Parallel<br />Data Warehouse</a></th>
965965
> </tr>
966966
> </table>
@@ -1179,7 +1179,7 @@ WITH STATS = 5;
11791179
> </tr>
11801180
> <tr>
11811181
> <th><a href="backup-transact-sql.md?view=sql-server-2016">SQL Server</a></th>
1182-
> <th><a href="backup-transact-sql.md?view=azuresqldb-mi-current">SQL DB<br />Managed Instance</a></th>
1182+
> <th><a href="backup-transact-sql.md?view=azuresqldb-mi-current">SQL Database<br />Managed Instance</a></th>
11831183
> <th><strong><em>* SQL Parallel<br />Data Warehouse *</em></strong></th>
11841184
> </tr>
11851185
> </table>

‎docs/t-sql/statements/create-database-transact-sql.md‎

Lines changed: 125 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -40,7 +40,7 @@ caps.latest.revision: 212
4040
author: CarlRabeler
4141
ms.author: carlrab
4242
manager: craigg
43-
monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017"
43+
monikerRange: ">=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-current||=azuresqldb-mi-current||=azure-sqldw-latest||>=aps-pdw-2016||=sqlallproducts-allversions"
4444
---
4545
# CREATE DATABASE
4646

@@ -50,7 +50,33 @@ Click one of the following tabs for the syntax, arguments, remarks, permissions,
5050

5151
For more information about the syntax conventions, see [Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md).
5252

53-
# [SQL Server](#tab/sqlserver)
53+
## Click a product!
54+
55+
In the following row, click whichever product name you are interested in. The click displays different content here on this webpage, appropriate for whichever product you click.
56+
57+
::: moniker range=">=sql-server-2016||>=sql-server-linux-2017||=sqlallproducts-allversions"
58+
59+
> [!div class="mx-tdCol2BreakAll"]
60+
> <table>
61+
> <tr>
62+
> <th> &nbsp; </th>
63+
> <th> &nbsp; </th>
64+
> <th> &nbsp; </th>
65+
> <th> &nbsp; </th>
66+
> <th> &nbsp; </th>
67+
> </tr>
68+
> <tr>
69+
> <th><strong><em>* SQL Server *<br />&nbsp;</em></strong></th>
70+
> <th><a href="create-database-transact-sql.md?view=azuresqldb-current">SQL Database<br />logical server</a></th>
71+
> <th><a href="create-database-transact-sql.md?view=azuresqldb-mi-current">SQL Database<br />Managed Instance</a></th>
72+
> <th><a href="create-database-transact-sql.md?view=azure-sqldw-latest">SQL Data<br />Warehouse</a></th>
73+
> <th><a href="create-database-transact-sql.md?view=aps-pdw-2016">SQL Parallel<br />Data Warehouse</a></th>
74+
> </tr>
75+
> </table>
76+
77+
&nbsp;
78+
79+
# SQL Server
5480

5581
## Overview
5682

@@ -855,7 +881,30 @@ GO
855881
[Databases](../../relational-databases/databases/databases.md)
856882
[Binary Large Object &#40;Blob&#41; Data &#40;SQL Server&#41;](../../relational-databases/blob/binary-large-object-blob-data-sql-server.md)
857883

858-
# [SQL DB logical server](#tab/sqldbls)
884+
::: moniker-end
885+
::: moniker range="=azuresqldb-current||=sqlallproducts-allversions"
886+
887+
> [!div class="mx-tdCol2BreakAll"]
888+
> <table>
889+
> <tr>
890+
> <th> &nbsp; </th>
891+
> <th> &nbsp; </th>
892+
> <th> &nbsp; </th>
893+
> <th> &nbsp; </th>
894+
> <th> &nbsp; </th>
895+
> </tr>
896+
> <tr>
897+
> <th><a href="create-database-transact-sql.md?view=sql-server-2016">SQL Server</a></th>
898+
> <th><strong><em>* SQL Database<br />logical server *</em></strong></th>
899+
> <th><a href="create-database-transact-sql.md?view=azuresqldb-mi-current">SQL Database<br />Managed Instance</a></th>
900+
> <th><a href="create-database-transact-sql.md?view=azure-sqldw-latest">SQL Data<br />Warehouse</a></th>
901+
> <th><a href="create-database-transact-sql.md?view=aps-pdw-2016">SQL Parallel<br />Data Warehouse</a></th>
902+
> </tr>
903+
> </table>
904+
905+
&nbsp;
906+
907+
# Azure SQL Database logical server
859908

860909
## Overview
861910

@@ -1166,7 +1215,30 @@ CREATE DATABASE TestDB3 COLLATE Japanese_XJIS_140 (MAXSIZE = 100 MB, EDITION =
11661215

11671216
- [ALTER DATABASE &#40;Azure SQL Database&#41;](alter-database-transact-sql.md?&tabs=sqldbls)
11681217

1169-
# [SQL DB Managed Instance](#tab/sqldbmi)
1218+
::: moniker-end
1219+
::: moniker range="=azuresqldb-mi-current||=sqlallproducts-allversions"
1220+
1221+
> [!div class="mx-tdCol2BreakAll"]
1222+
> <table>
1223+
> <tr>
1224+
> <th> &nbsp; </th>
1225+
> <th> &nbsp; </th>
1226+
> <th> &nbsp; </th>
1227+
> <th> &nbsp; </th>
1228+
> <th> &nbsp; </th>
1229+
> </tr>
1230+
> <tr>
1231+
> <th><a href="create-database-transact-sql.md?view=sql-server-2016">SQL Server</a></th>
1232+
> <th><a href="create-database-transact-sql.md?view=azuresqldb-current">SQL Database<br />logical server</a></th>
1233+
> <th><strong><em>* SQL Database<br />Managed Instance *</em></strong></th>
1234+
> <th><a href="create-database-transact-sql.md?view=azure-sqldw-latest">SQL Data<br />Warehouse</a></th>
1235+
> <th><a href="create-database-transact-sql.md?view=aps-pdw-2016">SQL Parallel<br />Data Warehouse</a></th>
1236+
> </tr>
1237+
> </table>
1238+
1239+
&nbsp;
1240+
1241+
# Azure SQL Database Managed Instance
11701242

11711243
## Overview
11721244

@@ -1227,7 +1299,30 @@ CREATE DATABASE TestDB1;
12271299

12281300
See [ALTER DATABASE](alter-database-transact-sql.md?&tabs=sqldbmi)
12291301

1230-
# [SQL Data Warehouse](#tab/sqldw)
1302+
::: moniker-end
1303+
::: moniker range="=azure-sqldw-latest||=sqlallproducts-allversions"
1304+
1305+
> [!div class="mx-tdCol2BreakAll"]
1306+
> <table>
1307+
> <tr>
1308+
> <th> &nbsp; </th>
1309+
> <th> &nbsp; </th>
1310+
> <th> &nbsp; </th>
1311+
> <th> &nbsp; </th>
1312+
> <th> &nbsp; </th>
1313+
> </tr>
1314+
> <tr>
1315+
> <th><a href="create-database-transact-sql.md?view=sql-server-2016">SQL Server</a></th>
1316+
> <th><a href="create-database-transact-sql.md?view=azuresqldb-current">SQL Database<br />logical server</a></th>
1317+
> <th><a href="create-database-transact-sql.md?view=azuresqldb-mi-current">SQL Database<br />Managed Instance</a></th>
1318+
> <th><strong><em>* SQL Data<br />Warehouse *</em></strong></th>
1319+
> <th><a href="create-database-transact-sql.md?view=aps-pdw-2016">SQL Parallel<br />Data Warehouse</a></th>
1320+
> </tr>
1321+
> </table>
1322+
1323+
&nbsp;
1324+
1325+
# Azure SQL Data Warehouse
12311326

12321327
## Overview
12331328

@@ -1328,7 +1423,30 @@ CREATE DATABASE TestDW COLLATE Latin1_General_100_CI_AS_KS_WS
13281423
[CREATE TABLE &#40;Azure SQL Data Warehouse&#41;](../../t-sql/statements/create-table-azure-sql-data-warehouse.md)
13291424
[DROP DATABASE &#40;Transact-SQL&#40;](../../t-sql/statements/drop-database-transact-sql.md)
13301425

1331-
# [SQL Parallel Data Warehouse](#tab/sqlpdw)
1426+
::: moniker-end
1427+
::: moniker range="=aps-pdw-2016||=sqlallproducts-allversions"
1428+
1429+
> [!div class="mx-tdCol2BreakAll"]
1430+
> <table>
1431+
> <tr>
1432+
> <th> &nbsp; </th>
1433+
> <th> &nbsp; </th>
1434+
> <th> &nbsp; </th>
1435+
> <th> &nbsp; </th>
1436+
> <th> &nbsp; </th>
1437+
> </tr>
1438+
> <tr>
1439+
> <th><a href="create-database-transact-sql.md?view=sql-server-2016">SQL Server</a></th>
1440+
> <th><a href="create-database-transact-sql.md?view=azuresqldb-current">SQL Database<br />logical server</a></th>
1441+
> <th><a href="create-database-transact-sql.md?view=azuresqldb-mi-current">SQL Database<br />Managed Instance</a></th>
1442+
> <th><a href="create-database-transact-sql.md?view=azure-sqldw-latest">SQL Data<br />Warehouse</a></th>
1443+
> <th><strong><em>* SQL Parallel<br />Data Warehouse *</em></strong></th>
1444+
> </tr>
1445+
> </table>
1446+
1447+
&nbsp;
1448+
1449+
# SQL Parallel Data Warehouse
13321450

13331451
## Overview
13341452

@@ -1455,4 +1573,4 @@ CREATE DATABASE mytest
14551573
[ALTER DATABASE &#40;Parallel Data Warehouse&#41;](../../t-sql/statements/alter-database-transact-sql.md?&tabs=sqlpdw)
14561574
[DROP DATABASE &#40;Transact-SQL&#41;](../../t-sql/statements/drop-database-transact-sql.md)
14571575

1458-
1576+
::: moniker-end

0 commit comments

Comments
 (0)