Enter Keywords:
1 - 10 of 26(0.001 seconds)
Sort By:
 
Does SQL Server CE have tables like Syscolumn in SQL server 2000?  Are there system tables that store system information other than just MSysObjects? Also, for some reason, I can access all tabl...
Zones: MS SQL ServerDate Answered: 08/27/2004 Rating: 8.6 Views: 0
Hi, I need to find all the table names in the database which have a column called 'StatusFrom'. How do I select from the syscolumns and sysobjects? And once I've retrieved this list, I need t...
Zones: MS SQL ServerDate Answered: 11/29/2004 Rating: 8.8 Views: 0
-- (SQL 2000) This query is to be run in a SP and yields the expected result, listing all matching tables in the current catalog (myDB): use myDB  -- can't do this line in a SP select objec...
Zones: MS SQL ServerDate Answered: 04/16/2009 Rating: 7.0 Views: 0
How can you tell if a table exists on a MSSQL database using T-SQL?. I can use an 'IF EXISTS (select * from syscolumns....' etc if one of the column names is unique, but what if this isn't the case??.
Zones: MS SQL ServerDate Answered: 05/03/2000 Rating: 7.0 Views: 0
I have a table called Campaigns.  Inside this table, I have a Camp_ID and a field that specifies whether  campaign is ACTIVE or not.... I also have another table tbl_CAMPAIGN_DETAILS that has the C...
Zones: MS SQL ServerDate Answered: 08/09/2005 Rating: 7.2 Views: 0
Can  table names be distinguished from field names on this table? Thanx in advance, G
Zones: MS SQL ServerDate Answered: 02/07/2006 Rating: 9.4 Views: 0
I would like to ge the list of tables which has the column "InvId"... How can I do this? should i use syscolumns table?  I am using sql server 2000
Zones: MS SQL ServerDate Answered: 01/17/2007 Rating: 9.4 Views: 0
Hi, I want to write a small script to compare and produce the missing columns of a table residing in another databases. I am attempting to do that with the following script, but is unsucessfu...
Zones: MS SQL ServerDate Answered: 09/18/2001 Rating: 9.2 Views: 0
Hi all the query below runs in Ms_sql server i want it's equivlant query in ms-access. is this possible? if not then what's the alternative SELECT a.name AS tablename, b.name AS columnname,...
Zones: MS AccessDate Answered: 08/24/2003 Rating: 9.4 Views: 4
How do I join syscolumns with sysobjects to get a list of tables that has a particular field in it?   select sysobjects.name, syscolumn.name from sysojects inner join on syscolumns on syscolumns...
Zones: MS SQL ServerDate Answered: 10/22/2004 Rating: 9.4 Views: 0