No announcements
Found 817110 threads
-
1 VotesDatabase Schema : Understanding the structure of database
To add on to Visakh's response, you can create a database ERD diagram by expanding the node for this Database in SSMS Object Explorer.Answered | 3 Replies | 1025 Views | Created by Sauthee - Saturday, July 14, 2018 7:40 AM | Last reply by Mohsin_A_Khan - Saturday, July 14, 2018 10:53 PM
-
0 Votes
Getting Just the Database structure
To get the structure, or schema, of the database, using the SQL information schema.columns and information schema.tables was exactly what I needed.Answered | 4 Replies | 5392 Views | Created by nickshippers - Monday, November 16, 2009 9:52 PM | Last reply by nickshippers - Tuesday, November 17, 2009 3:05 PM -
1 Votes
Copy database structure but not the data
When the scripts are finished, go to the top and change the name of the database, then run the scripts.Answered | 6 Replies | 63940 Views | Created by Judith Weader - Wednesday, February 13, 2008 3:40 PM | Last reply by Peter8444 - Wednesday, April 1, 2015 1:39 AM -
1 Votes
Best Structure for Billing Database?
You can look at the Free Data Models from Database Answers, probably in the "Customers" group or the "Retail" group, and find the most ...Answered | 2 Replies | 8008 Views | Created by C_Newbie01 - Tuesday, June 25, 2013 5:23 PM | Last reply by Van Dinh - Wednesday, June 26, 2013 8:30 AM -
2 Votes
create database structure?
i want to create a database structure for following : 1 member can have many ...Answered | 3 Replies | 1800 Views | Created by ashuthinks32 - Friday, December 20, 2013 4:39 PM | Last reply by Visakh16 - Tuesday, December 31, 2013 6:18 PM -
1 Votes
Microsoft CRM database structure
Hi Aussie, This is called Normalization of the database.Answered | 1 Replies | 6578 Views | Created by Aussie - Tuesday, July 13, 2010 8:46 PM | Last reply by Kasturi Rajesh - Tuesday, July 13, 2010 9:08 PM -
9 Votes
SSDT SQL Server Database Project File Structure
Now, I create or compare+add from a database and it creates everything in a <schema> structure from the root.Answered | 8 Replies | 14028 Views | Created by David Elish - Wednesday, December 7, 2011 3:23 PM | Last reply by Greg L. Wright (3M) - Friday, March 7, 2014 10:05 PM -
1 Votes
Hide/Encrypt Database Structure form DBA Users
@Olaf Helper I want to Hide the structure of the database from users so that they can't re-engineer the system !Answered | 6 Replies | 4456 Views | Created by adarwish - Thursday, December 27, 2012 3:12 PM | Last reply by AndyW59 - Saturday, November 19, 2016 4:08 AM -
0 Votes
Database Structure Updates with sync scopes provisioned
You can manually drop the tables that are created as part of provisioning and reprovision your database.Answered | 1 Replies | 9210 Views | Created by FireTek - Thursday, January 21, 2010 8:11 PM | Last reply by Patrick S. Lee - Thursday, January 21, 2010 9:54 PM -
2 Votes
Migrating only database structure having lakhs of objects
Refer this link for how to generate a DAC file Please vote if you found it ...Answered | 2 Replies | 930 Views | Created by juniorkiran - Thursday, March 8, 2018 10:28 AM | Last reply by juniorkiran - Tuesday, March 27, 2018 9:50 AM -
0 Votes
Export Database Structure with user permission
Hello, i want to export a Database structur from one instance to another.Answered | 3 Replies | 6946 Views | Created by M.IT - Tuesday, June 28, 2011 7:51 AM | Last reply by Arunraj.C - Tuesday, June 28, 2011 11:00 AM -
7 Votes
Copying a database structure (with or without data)
Are you having your database in App_Data folder?Answered | 11 Replies | 7237 Views | Created by DaveFromNH - Monday, October 11, 2010 3:19 PM | Last reply by DaveFromNH - Tuesday, October 12, 2010 7:29 AM -
0 Votes
Restore database preserving existing file/filegroup structure
No way to preserve the file struct.on Prod will restore with replace(overwrite). for reference u can script the prod databaseMohd Sufian www.sqlship.wordpress.com Please mark the post as ...Answered | 3 Replies | 3211 Views | Created by Andrea Caldarone - Tuesday, April 24, 2012 9:02 AM | Last reply by Mohammad-Sufian - Tuesday, April 24, 2012 1:27 PM -
0 Votes
Compare against schema, not whole database structure
Because of the change in infrastructure for Schema Compare, we need to follow the min permission set of reverse engineering which is View Definition of the database.Answered | 3 Replies | 4135 Views | Created by risogolo - Monday, December 1, 2008 6:03 PM | Last reply by risogolo - Wednesday, December 3, 2008 12:22 PM -
0 Votes
Exproting database structure
in addition you can use database export / import wizard to migrate the database from one server to the other.Answered | 3 Replies | 3937 Views | Created by mkvighania - Thursday, March 22, 2012 3:26 PM | Last reply by RamJaddu - Thursday, March 22, 2012 8:14 PM -
3 Votes
Struggling with database structures
Use the Access built-in Upsizing Wizard to create and transfer the data to your local SQL Server Express database.Answered | 8 Replies | 4508 Views | Created by Chet Force - Tuesday, September 20, 2011 6:35 PM | Last reply by Chet Force - Thursday, September 22, 2011 1:47 AM -
2 Votes
Check database structure changes from T-SQL
Everything else can be done in the database in T-SQL.Answered | 3 Replies | 1806 Views | Created by Avantix - Friday, March 15, 2013 12:26 PM | Last reply by Erland Sommarskog - Friday, March 15, 2013 2:22 PM -
1 Votes
Structures
"I need to initialize the size of structure " The size of the structure is fixed by its definition, you cannot change it at runtime.Answered | 8 Replies | 1086 Views | Created by Rajeswari_Raja - Tuesday, February 18, 2014 3:48 PM | Last reply by Richter03 - Thursday, February 20, 2014 10:26 AM -
2 Votes
Need Help Creating a Database using Structures and Arrays
I need a Data Type Structure for my intended purpose, which is to create a data Type/Structure that would allow Fixed-Length Random Access Records.Answered | 9 Replies | 2117 Views | Created by MartySmarty - Tuesday, November 15, 2011 2:03 PM | Last reply by Mike Feng - Friday, November 18, 2011 3:59 AM -
0 Votes
structure
typedef struct _test { std::string Group; std::string IP; ...Answered | 3 Replies | 743 Views | Created by Neptune123 - Saturday, April 16, 2016 6:43 PM | Last reply by Hart Wang - Sunday, April 17, 2016 6:56 AM - Items 1 to 20 of 817110 Next ›
No announcements
