database-schema

相关标签：javascript jquery android 多少钱 iPhone

SQL Server restore and backup per schema [duplicate]

This question already has answers here: 开发者_运维知识库 Closed 10 years ago. Possible Duplicate:[详细]

2023-02-27 11:43 分类：问答
oracle: select information about a function/procedure

I would like to retrieve information about procedures/functions from Oracle database. I know, that I can use ALL_PROCEDURES and USER_OBJECTS tables, but they only inform me about names of existing pro[详细]

2023-02-27 11:25 分类：问答
Collation Problem

Im getting differentcollation in different objects in a database... Collation of Tables is \'SQL_SwedishStd_Pref_CP1_CI_AS\'[详细]

2023-02-27 07:00 分类：问答
Compute canonical cover using armstrong's axioms

question:Determine the canonical cover using Armstrong’s Axioms.Give the axioms that you use to arrive at each step.[详细]

2023-02-27 03:56 分类：问答
How to get all columns' names for all the tables in MySQL?

Is there a fast way of getting all column names fr开发者_StackOverflow中文版om all tables in MySQL, without having to list all the tables?select column_name from information_schema.columns[详细]

2023-02-25 10:11 分类：问答
Creating Index on Table in a schema

I am logged in as \'sa\', with full admin rights, and I am running the following command: CREATE NONCLUSTERED INDEX [IDX_EntityAuditId] ON [Maintenance.EntityAuditMessagesArchive][详细]

2023-02-24 07:21 分类：问答
storing a schedule in mysql

I am interested in a way to store the schedule of my users. I need to save the day of the week and the hours when he is available.Could be from 8:00 to 12, or from 9:开发者_JAVA百科00 to 12 and then f[详细]

2023-02-21 23:27 分类：问答
When querying tables/fields in Oracle database, how to see table schema in query results? (using SQuirreL SQL)

At my workplace we have a database with multiple schemas, and some table names 开发者_StackOverflowmay be repeated in different schemas. There are thousands of tables so it is not time-effective to wa[详细]

2023-02-21 17:18 分类：问答
Subtype / SuperType Relationships: How to fulfill these requirements

I am fighting with myself trying to model a DB to fulfill certain requirements. There are two main entities.One is known as Team, think of a business or organization.The other will be an individual.[详细]

2023-02-21 17:14 分类：问答
DateTime + 2x Time vs. DateTime + Duration for storing time

I\'m trying to implement a ReservationController which is responsible for taking reservations of something for a specific time range. So far I guessed using one column for the Date (DateTime) and two[详细]

2023-02-21 09:49 分类：问答