Outline ·
[ Standard ] ·
Linear+
Making tables in database in Management studio
TStest.php
|
Oct 12 2016, 11:38 PM, updated 8y ago
|
Getting Started
|
this backend version is not supported to design database diagrams or tables in management studio 2014
there another way to bypass this. i forgot how. other than reinstalling other version/lastest version ect. i wan to create new table in database in Management studio SQL 2014
|
|
|
|
Eventless
|
Oct 13 2016, 07:32 AM
|
|
You can use sql commands to directly create the tables that you want(create table).
|
|
|
|
geekster129
|
Oct 13 2016, 07:49 AM
|
|
Which Microsoft SQL Server version is your database running on?
|
|
|
|
alien3d
|
Oct 13 2016, 09:33 AM
|
|
use heidi la
|
|
|
|
TStest.php
|
Oct 13 2016, 09:40 AM
|
Getting Started
|
QUOTE(alien3d @ Oct 13 2016, 09:33 AM) i have no idea what is that
|
|
|
|
TStest.php
|
Oct 13 2016, 09:40 AM
|
Getting Started
|
QUOTE(Eventless @ Oct 13 2016, 07:32 AM) You can use sql commands to directly create the tables that you want(create table). how do i do that? im still new at this
|
|
|
|
alien3d
|
Oct 13 2016, 09:42 AM
|
|
QUOTE(test.php @ Oct 13 2016, 09:40 AM) i have no idea what is that http://www.heidisql.com/ but still i prefer sql server management studio.. just download all the latest easy
|
|
|
|
TStest.php
|
Oct 13 2016, 09:45 AM
|
Getting Started
|
QUOTE(geekster129 @ Oct 13 2016, 07:49 AM) Which Microsoft SQL Server version is your database running on? im not sure what im looking at sqlexpress2014 express edition product version: 12.0.4212.0 Microsoft SQL Server Express (64-bit) im on windows 10 64bit
|
|
|
|
TStest.php
|
Oct 13 2016, 09:46 AM
|
Getting Started
|
QUOTE(alien3d @ Oct 13 2016, 09:42 AM) http://www.heidisql.com/ but still i prefer sql server management studio.. just download all the latest easy i dl the 2016. but somehow i check my install is 2014(express edition) if i redownload. will all my data/setting will be gone?
|
|
|
|
alien3d
|
Oct 13 2016, 09:46 AM
|
|
QUOTE(test.php @ Oct 13 2016, 09:46 AM) i dl the 2016. but somehow i check my install is 2014(express edition) if i redownload. will all my data/setting will be gone? setting.. should be not.
|
|
|
|
TStest.php
|
Oct 13 2016, 09:50 AM
|
Getting Started
|
QUOTE(alien3d @ Oct 13 2016, 09:46 AM) ok MS download before this i just download managemnet studio x64bit. so should i download the rest of the 64bit like express n tools?
|
|
|
|
alien3d
|
Oct 13 2016, 09:53 AM
|
|
QUOTE(test.php @ Oct 13 2016, 09:50 AM) ok MS download before this i just download managemnet studio x64bit. so should i download the rest of the 64bit like express n tools? just download la.. for me.. me lazy
|
|
|
|
TStest.php
|
Oct 13 2016, 09:56 AM
|
Getting Started
|
QUOTE(alien3d @ Oct 13 2016, 09:53 AM) just download la.. for me.. me lazy Ok i can skip the other 32 bits n the management studio. i try dl the rest
|
|
|
|
TStest.php
|
Oct 13 2016, 11:07 AM
|
Getting Started
|
No luck in reisntalling
|
|
|
|
Eventless
|
Oct 13 2016, 10:17 PM
|
|
QUOTE(test.php @ Oct 13 2016, 09:40 AM) how do i do that? im still new at this Assuming you have no problem in running sql commands, you could read through the link below to find out how to create a table using sql commands. https://msdn.microsoft.com/en-us/library/ms174979.aspxMost of the information that you need can be found in the help files.
|
|
|
|
TStest.php
|
Oct 14 2016, 03:04 PM
|
Getting Started
|
QUOTE(Eventless @ Oct 13 2016, 10:17 PM) Assuming you have no problem in running sql commands, you could read through the link below to find out how to create a table using sql commands. https://msdn.microsoft.com/en-us/library/ms174979.aspxMost of the information that you need can be found in the help files. ya i fix that few reinstall ect ect . now no problem creating table. but if i have no manually do table with the link u gave me im screwed
|
|
|
|