SQL Server: How To Create A Table Using SQL Script

Published: 07 June 2021
on channel: Saturday Night Coder
3,931
43

In this video we take a look at how to create a table using in SQL Server using SQL script within SQL Server Management Studio.

Notes:-

It's worth pointing out that when I mentioned choosing a larger size for columns that only refers to variable length columns that could be larger than anticipated i.e. free text. Of course if you actually know the size of the column and that is fixed, you should set your column sizes specifically.

Links:-

(Microsoft SQL Server Management Studio: How To Download & Use For Free)    • Microsoft SQL Server Management Studio: Ho...  

Script:-

CREATE TABLE [dbo].[Config](
[ID] INTEGER IDENTITY(1, 1) PRIMARY KEY,
[Key] VARCHAR(64) NOT NULL UNIQUE,
[Value] VARCHAR(512)
)
GO

If you enjoyed the video don't forget to like, comment and subscribe. Thanks for watching.


On this page of the site you can watch the video online SQL Server: How To Create A Table Using SQL Script with a duration of hours minute second in good quality, which was uploaded by the user Saturday Night Coder 07 June 2021, share the link with friends and acquaintances, this video has already been watched 3,931 times on youtube and it was liked by 43 viewers. Enjoy your viewing!