|
by: Pachydermitis |
last post by:
Hi I need to see all the indexes in a database. The ID has dbo rights
to the database, but not to the master. I can't see anything in
INFORMATION_SCHEMA.CHECK_CONSTRAINTS or
INFORMATION_SCHEMA.KEY_COLUMN_USAGE
An sa ID for the master sees everything however.
Thanks for your help
Pachydermitis
|
by: Tina Harris |
last post by:
I ran the following query in Query Analyzer for a 7 column table.
SELECT c.name,c.colid FROM syscolumns c WHERE c.id=925962375 ORDER BY
c.colid
The results were:
I_CSD 1
X_STE_XML 2
I_USR_LCK 4
T_CRT_RCD 5
|
by: Dave Sisk |
last post by:
Hi Folks:
I'm a little new to SQLServer, so please pardon my ignorance!
I've found the INFORMATION_SCHEMA views for TABLES, COLUMNS, and
TABLE_CONSTRAINTS. I'm looking for the views that will give me the list of
columns by constraint.
For instance, if Table1 has a unique key called Table1_UK01, I can find that
under INFORMATION_SCHEMA.TABLE_CONSTRAINTS. But I also need to know the
|
by: Mark Johnson |
last post by:
Is it possible that "information_schema.schemata" does not allways work
correctly in MSDE Sql-Server.
I have built an Explorer that will find the Servers (MSDE and SQL-Server
2000) and then should list the Databases found.
For the SQL-Server the results are always correct but not for MSDE.
Mostly Databases are missing allthough the results are often diffrent.
Selden are all of them there, mostly my two Database are effected in some...
|
by: mike.griffin |
last post by:
This is part of the Columns View, if you add a numeric field to your table
and don't provide any Length or Precision then :
numeric_precision is returned as 65535
numeric_scale is returned as 65531
Is this what you'd expect, and what does it mean to create a column with
no Length or Precision, I'm using pgAdmin to create the tables and
columns, but the tables are created and seem to work.
|
|
by: BB |
last post by:
Hi There,
just moved over from SQL Server to mySQL and finding my way about. In
SQL Server there was a way of retrieving (and setting) metaproperties
for columns and tables. The closest I see to this is the
TABLES.table_comment COLUMNS.column_comment fields in the
INFORMATION_SCHEMA 'Database'.
How do you set these values? Seems like you cannot amend values within
these tables. I am using version 5.0.27.
|
by: parkc |
last post by:
How do you change the order of key columns in a primary key and view the difference between two tables that have the same name?
For example, table x has a primary key called pk_x. PK_x contains two key columns x and y in the order 1 and 2 now I want to change it so that columns x and y are 2 and 1. How do I do that?
|
by: Shrek |
last post by:
if I select character_maximum_length from INFORMATION_SCHEMA.COLUMNS
if returns -1 on columns that are defined as varchar(max)
is this normal???
|
by: amit2781 |
last post by:
Hi,
I have created 4 tables in 'amit' database and then I deleted them. Still I able to get information about the table_schema for the table deleted.
After drop table when I fire a query for table_schema from information_schema.tables it will give me result as 'amit'. I didn't understand why it is happnes.
See the below steps done.
mysql> use amit;
mysql> show tables;
+----------------+
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
|