What is the meaning of information_scehma.tables view
when i create database db1 , later i created a schema called schema1
then i created a table called tbl1 in the schema schema1
what doe...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22892617.html
Hi experts,
How can I find the columns that an index consists of.
I know I can get the primary key columns from the INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE view but cant figured out how, i...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20542769.html
Zones:
MS SQL ServerDate Answered: 03/11/2003 Rating: 9.4 Views: 0
I have written code to manipulate a VIEW
I have a SP that will get the contents of the view and then parse it. The SQL to get this info is :
SELECT @SQL = VIEW_DEFINITION
FROM {Table...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20634183.html
Zones:
MS SQL ServerDate Answered: 06/06/2003 Rating: 7.6 Views: 12
I am using the Information Schema to retrive a list of tables and their columns:
SELECT TABLE_NAME, COLUMN_NAME,
DATA_TYPE, CHARACTER_MAXIMUM_LENGTH,
ORDINAL_POSITION
FROM INFORMATION_SCHEMA....
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20959760.html
Zones:
MS SQL ServerDate Answered: 04/19/2004 Rating: 9.2 Views: 0
I'm writing a little asp script that gets the table's schema information (column names, data types, maximum length and so on...) then it gets all of the information in that table and displays it fo...
http://www.experts-exchange.com/Database/Miscellaneous/Q_21019130.html
I'm looking to be able to generate a script or text description of indexes against a table. I see within the numerous system tables little pieces of relevant information, but I was wondering if the...
http://www.experts-exchange.com/Database/Miscellaneous/Q_21371894.html
Zones:
DatabasesDate Answered: 03/31/2005 Rating: 9.0 Views: 0
Is there any way to simply request the schema information for a particular table (not to be confused with overall schema - JUST the table) in an Oracle database.
I know it can be done in SQL Serve...
http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/Q_21513780.html
Is there any Information_schema view for Trigger?
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21960169.html
Zones:
MS SQL ServerDate Answered: 08/19/2006 Rating: 9.0 Views: 17
What's better to use in SQL Server 2005: information_schema or sys.objects?
Thanks
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2260...
I was mucking around in the web config file trying to solve a sys undefined error and now I am getting "Could not find schema information for the element 'http://schemas.microsoft.com/.NetConfigura...
http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/Q_22844904.html
