Managing Tables and Columns in SQL Server

Q

Where to find answers to frequently asked questions on Managing Tables and Columns in SQL Server?

✍: FYIcenter.com

A

Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Managing Tables and Columns in SQL Server. Clear answers are provided with tutorial exercises on creating, renaming, and deleting tables; reviewing, renaming, deleting and adding table columns; changing column data types.

What Is a Table in SQL Server

DDL (Data Definition Language) Statements for Tables? in SQL Server

CREATE TABLE - Creating New Tables in SQL Server

"sys.tables" - Getting a List of All Tables in SQL Server

"sys.columns" - Getting a List of Columns in a Table in SQL Server

"sp_columns" - Getting a List of Columns in a Table in SQL Server

"sp_help" - Getting a List of Columns in a Table in SQL Server

Generating CREATE TABLE Script on Existing Tables in SQL Server

"SELECT ... INTO" - Creating New Tables With Queries in SQL Server

"ALTER TABLE ... ADD" - Adding New Columns to Existing Tables in SQL Server

"ALTER TABLE ... DROP COLUMN" - Deleting Existing Columns in SQL Server

"sp_rename ... 'COLUMN'" - Renaming an Existing Column in SQL Server

Renaming an Existing Column with Management Studio in SQL Server

"ALTER TABLE ... ALTER COLUMN" - Changing Column Data Type in SQL Server

"sp_rename ... 'OBJECT'" - Renaming Existing Tables in SQL Server

"DROP TABLE" - Deleting Existing Tables in SQL Server

⇒ What Is a Table in SQL Server

⇐ System Databases Used by SQL Servers in SQL Server

⇑⇑ SQL Server Database Tutorials

2016-11-20, 3252🔥, 0💬